View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default 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?