Thread: Select first 3 sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Select first 3 sheets
Hi StephanieH,

Try:

Sheets(Array(1, 2, 3)).Select

---
Regards,
Norman



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



Reply With QuoteReply With Quote