Select first 3 sheets
Perfect. Thanks Norman and Tom.
Doug, I think you've specified "Sheet1" as the sheet name, which is what I'm
avoiding.
"StephanieH" wrote:
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?
|