Dear experts
I have a list of values in Column A that I want to loop through using this code and save as a text file.
I've managed to write the code below to run one value at a time and modifying it manually. So, I have to keep changing the "i.value = CE" and the "FileName", respectively everytime, which is madness when you have to do this more than 50 times.
I've attached a sample workbook with the module for testing.
Any help would be much appreciated
Thank you
Please Login or Register to view this content.
Bookmarks