Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like Function
Hi Nigel,
Try: Like "Daily*" --- Regards, Norman "Nigel" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like Function
Not .Name Like "Daily*" Then
-- Regards, Tom Ogilvy "Nigel" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like Function
hi, Nigel !
... 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... trying to accomplish ... code to not run on any spreadsheet with the word Daily at the begining of it name plus the other name sheets maybe an alternate approach ? If InStr(1, .Name, "daily", vbTextCompare) = 0 Then Select Case Application.Trim(LCase(.Name)) Case "menu", "login", "report", "report 2" ' do nothing Case Else ' do something End Select End If hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |