loop through worksheets for each sheet after

J

J.W. Aldridge

for each sheet after "data sheet"....

How to loop through each sheet and run macro1, then macro2 before
going to the next sheet?
 
J

JLGWhiz

x = Sheets("data sheet").Index
For Each sh in ThisWorkbook.Sheets
If sh.Index > x Then
'Do something
End If
Next
 
Top