WorksheetFunction OR
 

I have the following to test if the input from inputbox contains the name
"Jacqueline" or "Mary". However it returns the message "Unable to get the OR
property of the worksheet function class". Anyone know what is wrong?

If Name Like WorksheetFunction.Or("*Jacqueline*", "*Mary*") Then

WorksheetFunction OR
 

If Name Like "*Jacqueline*" OR _
Name Like "*Mary*"Then


although I don't think I would use Name as a variable

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"linglc" wrote in message
...
I have the following to test if the input from inputbox contains the name
"Jacqueline" or "Mary". However it returns the message "Unable to get the
OR
property of the worksheet function class". Anyone know what is wrong?

If Name Like WorksheetFunction.Or("*Jacqueline*", "*Mary*") Then