If excel worksheet name <> "Summary" OR "SummaryClient" Then

Hi Experts,

The code below works fine:
        If xlSheet.Name <> "Summary" Then
            xlSheet.UsedRange.ClearContents

But, I now need to adda second worksheet:
Attemtp 1: If excel worksheet name <> "Summary" OR "SummaryClient" Then
Attempt 2: If excel worksheet name <> Like "Summary*" Then

What's the best way to do this?

Thks in advance!
Steven
scsnow2310Asked:
Who is Participating?
 
mbizupCommented:
If xlSheet.Name <> "Summary"   AND xlSheet.Name <> "SummaryClient" Then
0
 
scsnow2310Author Commented:
Great - Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.