View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Laurence Lombard Laurence Lombard is offline
external usenet poster
 
Posts: 24
Default If statement with "OR"

Is there a shorthand way of working "OR" into an if statement in a
similar as used in the CASE statement

if Person = "Peter", "Paul", "John" then...

along the lines of
Select Case Person
Case "Peter","Paul","John"...

if Person = "Peter" or Person = "Paul" or Person = "John" then...
is a bit bulky