Array that selects multiple sheets based on cell string

[Andy Swain]

I have a macro that publishes multiple sheets to a single pdf - it works fine

The range of sheets will depend on the task I'm doing so I'm trying to write code that will be responsive

I have a cell that creates the sheet names of the required sheets and concatenates them into a string eg

"Cert1", "Cert2", "Cert3", "Cert4"

This result appears in N15 and I'm trying to use this string below - everything I've tried so far has been 'subscript out of range' at the line "Sheets(Array(i)).Select"

Any help gratefully received

Please Login or Register  to view this content.

[1aaaaaaaaaaaaaaa]

Hi, if you could provide a sample workbook (remove any personal or confidential information) that would help us to better solve for your use case, thank you

[1aaaaaaaaaaaaaaa]

Something like this might work in this case.. (see attached)

[CK76]

In N15 put this.

Please Login or Register  to view this content.

Then code would be like...

Please Login or Register  to view this content.

[Andy Swain]

Spot on! Many thanks CK76