View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EagleOne EagleOne is offline
external usenet poster
 
Posts: 68
Default 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