View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adele Adele is offline
external usenet poster
 
Posts: 6
Default Selecting mulitple worksheets to Print (using VBA)

I need to select a user defined list of worksheets all at once using VBA.

I have a string variable containing a list of selected worksheets.
for example: mystring = "Sheet1,"&"Sheet2,"&"Sheet3"

Is it possible to pass the variable mystring as an argument in the following
function:
Sheets(Array(mystring)).Select without it generating an error message ?

Or is there another way of selecting worksheets at once using VBA ?