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? |
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