Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through specific worksheets
I am familiar with the code to loop through all the worksheets in a workbook
with a "For Each ws in Worksheets" construct but I would like a routine to be confined to a selection of named worksheets within a workbook. Let's say the worksheet names are in a range called "MyList" in a worksheet called "Control". What code should I use to apply my routine only to the worksheets in "Mylist". Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop worksheets | Excel Discussion (Misc queries) | |||
Macro/Loop If Statement Help -delete the row with the specific te | Excel Programming | |||
Loop thru some worksheets | Excel Programming | |||
Loop Through worksheets | Excel Programming | |||
Loop worksheets | Excel Programming |