Select first 3 sheets
Stephanie,
The mismatch is because it's looking for strings (sheet names):
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
hth,
Doug
"StephanieH" wrote in message
...
I need to select the first 3 sheets in my workbook, regardless of their
names. I've tried
Sheets(Array(Sheets(1), Sheets(2), Sheets(3))).Select
but I get "Type Mismatch"
What am I doing wrong?
|