Thread: Select first 3 sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StephanieH StephanieH is offline
external usenet poster
  
Posts: 95
Default Select first 3 sheets
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