Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot print both-sided by selecting multiple worksheets | Excel Discussion (Misc queries) | |||
Counting values in mulitple worksheets | Excel Discussion (Misc queries) | |||
How do I sum totals from mulitple worksheets | Excel Worksheet Functions | |||
mulitple worksheets vlookup | Excel Discussion (Misc queries) | |||
Changes to Mulitple Worksheets | Excel Worksheet Functions |