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)
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:
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).
I would like to have a VBA Sub which would do the following:
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...
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...
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...
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...
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. :
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...
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...