FOR EACH
 

hello

i would like to loop some code for sheets 3 to 17 of a
workbook, but I'm not really sure of the syntax? Any ideas?

FOR EACH
 

Greg,

Try something like

Dim Ndx As Long
Dim WS As Worksheet
For Ndx = 3 To 17
Set WS = Worksheets(Ndx)
' do something with WS
Next Ndx

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GREGORY" wrote in message
...
hello

i would like to loop some code for sheets 3 to 17 of a
workbook, but I'm not really sure of the syntax? Any ideas?