Right now I have a loop that selects sheets in the workbook like this:
Instead of selecting all sheets 2-100, I need only to select specific ones. So in the first sheet in cells P1:P100, I have which worksheet numbers (can be names vs. numbers as well) need to be selected. Some cells will have a number and some will not. So for example, cell P1 has 1, P2 is empty, P3 empty, P4 has 4, P5 has 5 and so on. How can I select only those sheets that are identified in column P? I'm guessing I need to refer to range P1:P100 as a vector and delete blanks from it, then select only those sheet numbers(or names) that are in the vector. Just not sure how to do that.For i = 2 To 100 Worksheets(i).Select (False) ActiveSheet.Range("H101").Select Next i
Thank you
Bookmarks