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

search over range of worksheets
 

for iWS = worksheets("alpha").index to worksheets("queen").index
set ws = worksheets(i)
next i

HTH
--
AP

"Kanga 85" a écrit dans le message de
news: ...
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

search over range of worksheets
 

Thanks Ardus Petrus

"Ardus Petus" wrote:

for iWS = worksheets("alpha").index to worksheets("queen").index
set ws = worksheets(i)
next i

HTH
--
AP

"Kanga 85" a écrit dans le message de
news: ...
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