selecting sheets defined in an array

[luv2glyd]

Right now I have a loop that selects sheets in the workbook like this:

Please Login or Register  to view this content.

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.

Thank you

[Trebor76]

Hi luv2glyd,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[Norie]

What do you want to do with the selected sheets?

[luv2glyd]

Hi Robert, thank you for the code! Works perfectly for what I need and saves a lot of time.

Norie, I actually have 1000 sheets with data in them and need to paste over some formulas into specific ones depending on other variables. First I copy the formulas, then select desired sheets and paste - so far the most efficient way I found.

[Trebor76]

I actually have 1000 sheets

In my humble opinion a workbook should not have anywhere this number of sheets. There must be a more efficient way of doing things.

In any case, thanks for marking the thread as solved and for the rep

Robert

[luv2glyd]

Lol. That's the only way of doing what am I doing.... that I know of so far. Tomorrow it maybe completely different, lol. You're welcome.