| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro on all sheets in workbook after specific sheet
for all sheets that are after master data worksheet, run macro
"fildownid" Sub loopthroughanddo() x = Sheets("master data").Index For Each sh In ThisWorkbook.Sheets If sh.Index x Then Application.Run "fildownid" End If Next End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run macro on all sheets in workbook after specific sheet
Sub loopthroughanddo() For Each sh In ThisWorkbook.Sheets if Ucase(sh.name) < "MASTER DATA" THEN call fildownid End If Next End Sub "J.W. Aldridge" wrote: for all sheets that are after master data worksheet, run macro "fildownid" Sub loopthroughanddo() x = Sheets("master data").Index For Each sh In ThisWorkbook.Sheets If sh.Index x Then Application.Run "fildownid" End If Next End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select specific sheets and copy to new workbook | Excel Programming | |||
| Renaming all sheets in a workbook according to a specific cell. | Excel Programming | |||
| Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible? | Excel Programming | |||
| Copy specific Sheets and save them as a workbook | Excel Programming | |||
| Finding specific sheets within a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
