View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abxy[_59_] abxy[_59_] is offline
external usenet poster
 
Posts: 1
Default VBA Worksheets() term

Hi all,

Is there anyway I can reference all sheets in the workbook, or eithe
all sheets in between (sheets that i've named) "Top" and "Bottom" usin
the Worksheets() term in vba?

I know that i can use the Sheets(Array("Sheet1", "Sheet2", ...)) ter
but that's not gonna fly in this case cause the work book is update
daily and i can't reference specific sheets unless it's something lik
every sheet between "this sheet" to "that sheet".

Thx :

--
Message posted from http://www.ExcelForum.com