Subset of worksheets

[jlt199]

I have a workbook with lots of sheets, I'm only interested in a subset of sheet names. These I entered into a worksheet called MacroInfo in the same workbook. I want to loop through each worksheet and if it's name is one of the subset then do something.

I have this code for a fixed set of sheet names

Please Login or Register  to view this content.

Now, trying to get the sheet names dynamically from the MacroInfo worksheet

Please Login or Register  to view this content.

But I get nothing. Even when I hard code the range to "G1:G8"

Any ideas what I'm doing wrong?

Thanks

[Solus Rankin]

Please Login or Register  to view this content.

Untested.

[Norie]

If sheetNames is populated from more than one cell it will be a 2-dimensional array.

So you would get an error here.

Please Login or Register  to view this content.

Why not loop through the sheet names?

Please Login or Register  to view this content.

[jlt199]

Thanks alot for your quick replies.

Norie, I had to make a slight change to your code

Please Login or Register  to view this content.

Can I now extend this code to test that a sheet of that name exists before setting ws to it?

I've tried using the function

Please Login or Register  to view this content.

But I can't get it to look in the right workbook, despite several different attempts. Are you able to help with this please?

Thanks

[jlt199]

Nevermind, I've got it working thanks