Thread: if with or
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default if with or

hi! I have to use very many if ...end if in my code. to save some space I
want to use if with or (i know this works but i have forgotten the code). Eg

If A(i) = "AAA" Then
A(i) = 1
if A(i) = "Aaa" Then
A(i) = 1
End If
end if

instead i want to have:

If A(i) = "AAA" or "Aaa" Then
A(i) = 1
End If

but i have forgotten how it is written. please help me!