How to increment within For Next Loop
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
|