Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ryan Anderson   on Aug 11 In MS Office Category.

  
Question Answered By: Lonnie Rogers   on Aug 11

My own preference for this type of thing is to use a Select statement.

I'd also change the name to Uppercase so there was no mistakes in the
compare.

This would look something like...

For Each wSht In Worksheets
Select case Ucase(wSht.Name)
Case "SHEET1", "SAMPLE"
'Do Nothing

Case Else
'Code for rest  of sheets

End Select
Next wSht

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on For Each (If Next) Next Or get search suggestion and latest updates.


Tagged: