Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step through sheets, but exclude one
Hi All.........
I use code similar to the following to step through all the sheets in a workbook and perform a certain task thereon. It works fine, except that I would like for the sheet named XXXYYYZZZ to be left alone and the operation(s) NOT performed thereon. How might I exclude just that one sheet, yet perform all the operations on all the other sheets? Dim sh As Object Dim i as long i = 0 For Each sh In Sheets i = i + 1 Sheets(i).Select Call MyTaskCode next TIA for suggestions Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Exclude Sheets from Macro | Excel Programming | |||
Edit code - exclude sheets | Excel Programming | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
an array to step through sheets | Excel Programming |