View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kanga 85 Kanga 85 is offline
external usenet poster
 
Posts: 34
Default search over range of worksheets

I have 30 worksheets in the workbook, but I only want to search from "alpha"
to "queen" (putting various results in "Results").
How do I program for each worksheet form "alpha" to "queen"?
'For each ws in Thisworkbook.Worksheets ....'

(note: I have a changing number of worksheets between "alpha" and "queen" so
I cannot use 'worksheets.count')

Thanks