Sub TraverseSheets
dim wks as worksheet

for each wks in worksheets
msgbox wks.name
wks.range("A5:A10").select
next wks
end sub

--
HTH...

Jim Thomlinson


"djh" wrote:

What is the correct syntax to process through all sheets in a workbook when
you do not know how many sheets there will be? I want to have a macro run to
delete certain rows in each sheet, but the number of sheets will vary.