Hello,
I have this whole table from webpage
Capture.PNG
put into array
How to put market values to list with commas between them and paste all that to one cell in excel?
Please Login or Register to view this content.
f.e. A1 should contain text: "3523 95, 3523 AR, TD559W, FSK7366, CI-SB-2210, 3523 95, 3523 AR, JBU702"
Table rows count may vary in other pages.
Last edited by rcurious; 05-12-2021 at 02:55 AM.
Change references where required.
Please Login or Register to view this content.
Thank you.
I also found this way:
Please Login or Register to view this content.
Whichever code is best for you that works. Keep in mind future adaptations and maintenance.
You can shorten your code slightly.
Good luckPlease Login or Register to view this content.
Thank you. Optimized code also works. And yes, I'd better put that in separate method and comment well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks