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 ?
Bookmarks