vba If condition help..

[Mallesh23]

Hi Team,


Is there a way to shorten this code used in if condition.
If Sheet1.Cells(i, 1).Value = "Green" Or Sheet1.Cells(i, 1).Value = "Red" Or Sheet1.Cells(i, 1).Value = "Blue" Then

like If Sheet1.Cells(i, 1).Value = Array("Green", "Red", "Blue") Then


Thanks in advance



Regards,
mg

 

[Peter_SSs]

Hi Peter,
Thank you so much for giving multiple option, I will practice on it and improve my coding.


Regards,
mg

You're welcome.

The option using Instr that I gave in post 2 was not quite correct. I have edited that code so if you are testing, be sure to re-visit post 2 to get the correct code.