loop through worksheets for each sheet after

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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?
 
x = Sheets("data sheet").Index
For Each sh in ThisWorkbook.Sheets
If sh.Index > x Then
'Do something
End If
Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Reference sheets named by DAY 7
Looping through checkboxes 5
WorksheetFunction.Match Usage? 9
Search other sheets for numbers & color them 10
Arithmetic with Cell Dates 1
run macro each sheet after and then copy range 1
How to hide password? 1

Back
Top