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
|