Thread: multiple if's
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default multiple if's

I have to convert many accounts to a new account string. I have many
Or's. Is there a better way to code this? ( I actually have 16 Or's- I
only show 4 for the example):

For Each cll In Selection
old = Right(cll, 4)
If old = "0101" Or old = "0102" Or old = "0103" Or old = "0104"
Then
CONVERT CLL
End If
Next


Thanks