ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   loop through worksheets for each sheet after (https://www.excelbanter.com/excel-programming/426907-loop-through-worksheets-each-sheet-after.html)

J.W. Aldridge

loop through worksheets for each sheet after
 
for each sheet after "data sheet"....

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

JLGWhiz[_2_]

loop through worksheets for each sheet after
 
x = Sheets("data sheet").Index
For Each sh in ThisWorkbook.Sheets
If sh.Index x Then
'Do something
End If
Next



"J.W. Aldridge" wrote in message
...
for each sheet after "data sheet"....

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





All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com