• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by inddon

  1. I

    Search for a character/string, get the location's whole word..

    Please ignore my previous post (11), my mistake The code works perfect :):awesome: Thank you @Marc L
  2. I

    Search for a character/string, get the location's whole word..

    Hello @Marc L Thank you for taking the time for the code. Never used Wend, good to know. I executed the code, it displays the second part of the output correct. The first part gets missed out (attached a printscreen) Please advise Regards, Don
  3. I

    Search for a character/string, get the location's whole word..

    If you consider this as an assignment then I will buy you some beer (if it is okay with you) :) I should have solved it by yesterday. But whenever you have time available and can look into it, that would be wonderful :awesome:
  4. I

    Search for a character/string, get the location's whole word..

    Hello p45cal, All I know is, I am seeking your help. I wrote the code and it turned out to be too lengthy & messy one. Discarded it at the end. I am looking forward for a smarter way to get this working and learn too. That is why the post in the forum (with detail description). Regards, Don
  5. I

    Search for a character/string, get the location's whole word..

    Hello @Marc L, @p45cal Thank you for your repsonse. Attached a sample workbook with the explanation for your reference. Regards, Don
  6. I

    Search for a character/string, get the location's whole word..

    Thank you p45cal. The formula would be useful. I will kepp this in mind. For my requirement it has to be in VBA. I will post a sample workbook soon as requestd by Marc Regards, Don
  7. I

    Search for a character/string, get the location's whole word..

    Hello There, I would like to have a VBA Sub which would do the following: Below varaibles: a. l_Paragraph = "A string is any series of characters that are interpreted literally by a script. :x_For example, hello world :x_and LKJH019283 are both examples of strings. In computer...
  8. I

    Reflect comma (,) separated plain text from a variable into a Table

    Super. Thank you @p45cal :)
  9. I

    Reflect comma (,) separated plain text from a variable into a Table

    Wow, this works good. :):awesome::cool: Thank you very much @p45cal for taking the time to make it work. This is very useful and I have learned something good from you. I will study your solution specially the array part. I will try it out with a bigger lText_CSV value. Based on your solution...
  10. I

    Reflect comma (,) separated plain text from a variable into a Table

    Hello @p45cal Thank you for your reply. There is no physical file assigned to lText_CSV. The variable lText_CSV gets the value assigned from a API Webservice response and should be dumped into an Excel Table. This is the reason I included a small sample data assigned to lText_CSV, imitating...
  11. I

    Reflect comma (,) separated plain text from a variable into a Table

    Hello there, I have the below variable which stores a text string (comma separated) from some previous process. This needs to be reflected in a table (to be placed on Table Header Column 2). Please find attached the Sample Workbook.xlsm, which copies the variable string in the clipboard and...
  12. I

    Get PC Device, Windows & Excel Information using Win32 library

    Hello There, I would like to have a VBA Function(s) which would get the below information and return the result as a String. I tried to search on the web and got some but not all the values. My code is quite messier and it takes quite some time to get the results. : Win32_ComputerSystem...
  13. I

    Delete any data/table exists in a given range.

    Hello @vletm Thank you for the DoEvents tip. It did improve the performance I tweaked your code to first check if the cursor is in a table. Then look for special cells, after clearing check if the range is clear then exit for as below. Somehow it is working much better. Thanks again for your...
  14. I

    Delete any data/table exists in a given range.

    Hello @vletm Your solution worked so far very good (below mentioned with a slight modification) Recently, there came quite a large range. The Excel file was freezing (Not Responding). I searched a lot for the possible options and added some lines of code, still the freezing issue remained...
  15. I

    Loop through table columns and set the entire column format based on a condition

    Wonderful! Thank you it works good Regards, Don
Top