Thread: Like Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 141
Default Like Function

One of those days today,

I am using the following if statement in some code

If Not .Name = "Menu" And Not .Name = "Login" And Not .Name = "Report" And
Not .Name = "Report 2" And Not .Name Like "Daily" Then

do something

end if

It will ignore the sheets named except the Daily one. What I am trying to
accomplish is for the code to not run on any spreadsheet with the word Daily
at the begining of it name plus the other name sheets

Thanks