Select multiple sheets based on a the value of a range name

[billj]

Hi everyone,

I got a puzzle about using the range name for a worksheet selection. The name PrintWhat_ refers to a cell which has the value:

"Master", "T1"

Now I used the code below in the hope of selecting tabs of Master and T1:

ws = Range("PrintWhat_")
ThisWorkbook.Sheets(ws).Select

but this resulted in an run-time error '9'.

[billj]

Do I really have to split the cell values of "Master", "T1" into two separate cells? So one will be Master, and the other will be T1.

Hope there is an easy way to do that.

[skywriter]

You can try this.

Please Login or Register  to view this content.

[billj]

Hi skywriter, thanks for your kind reply.

I just want to select all sheets (separated by ",") all together based on the range name of PrintWhat_. For example, if PrintWhat_ is equal to "Master", "T1", then these two sheets will be selected. This will then allow me to do operations from there. How can I do that? Thank you.

[Norie]

Try this.

Please Login or Register  to view this content.

Note, if you didn't use " around the names the Replace wouldn't be required.

[billj]

Hi, skywriter, i can understand the purpose of the msgbox now. that is exactly what I need. Thank you.

[billj]

Thanks a lot, Norie.