View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Enrico[_3_] Enrico[_3_] is offline
external usenet poster
 
Posts: 2
Default selection of several worksheeets

Hi

I'd like to select several excel worksheets using a VBA macro.
I know: Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select
But how can I do it without specifying each sheet name?
For example using something like ... from sheet 3 to sheet 8 ... .Select?

If possible, please help me.
Thank you.
Entaf