Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
2003
With in the following loop: For Each wks In Worksheets (I am trying to increment to "Next" wks in Worksheets if any sheets listed in the array occur) If wks.name = Array("Do not process1","Do not process2", _ "Do not process3") Then _ Next wks Next wks I do not think that I can wks = wks +1 as wks is not numeric Also, I may not be handling the array properly. How can I have the For ... Next loop skip all worksheets named as in the array? Thanks EagleOne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
'Scroll bar' - to increment btwn MIN and MAX value. | Charts and Charting in Excel | |||
Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
Loop gone crazy | Excel Discussion (Misc queries) | |||
Do Loop | Excel Discussion (Misc queries) | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) |