View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris M Chris M is offline
external usenet poster
 
Posts: 8
Default loop through a certain group of worksheets only

Hello all,

In a workbook with several worksheets, I need to adjust something in any
worksheet with a name beginning with "Day" (ie, process all worksheets like
"Day 1", "Day 2", etc.) I will not know how many "day" sheets there are.
Also, the file name will always be different.

What would be a simpler/effective loop that I could use for this and other
similar files?

Thanks!!
--
Chris M