Hello,
I would like to perform the same task (which I have code for already prepared) on various worksheets. This task, however, can not be done unless the worksheet is open, so considering a have 30 worksheets for which I wish the perform the task, I need to create a loop.
I can do this easily enough using an array of worksheets within the VBA code. However, the worksheets I use may change over time. Rather than having my colleagues (who are not necessarily familiar with VBA) try to change the array in the code, I'd like them to be able to just go to some sheet "Control Page" for example, and add to / make changes to a list of sheet names in column A. I'd like the macro to keep looping through sheets based on these cells until there's an empty cell, in which case, the macro ends.
The list of sheets names for the macro to use may grow larger / smaller / stay the same size but different sheets, so finding the empty cell should be the best way to finish?
So, to summarise:
-A macro is needed to loop through worksheets to perform a function
-Ideally would like the worksheets to be defined in column A and keep going until a cell in column A is ""
Thanks you!
Bookmarks