VBA for Array of sheet values

[philozelda]

Hey gents - I'm looking to automate a line of code to copy worksheets from a list of sheet values.

Here is the code I got from the macro recorder:

Please Login or Register  to view this content.

Instead of adding all of the sheet names into the above code one by one, I'd like to refer to a list of sheet names found on a sheet called Lists!G2:G10 (this list could grow or shrink).

How can I do this?

[Bernie Deitrick]

Create a dynamic named range SheetNames, with nothing else in column G of Lists - with the refers to being

=OFFSET(Lists!$G$2,0,0,COUNTA(Lists!$G:$G),1)

or this, is your list has a header -

=OFFSET(Lists!$G$2,0,0,COUNTA(Lists!$G:$G)-1,1)

and use code like this:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[sakmsb]

Or loop over thru:

Please Login or Register  to view this content.