I have the following lines in my code:

ActiveCell.FormulaR1C1 = "=IF(RC[6]=""AA"",""ST"",""EA"")"
Range("D2").Select

This sets the value of one cell to ST if another equals AA, if not it sets
the value to EA. I have now found that AA may be AA or AB or AX but I still
need the second cell to be set to ST or EA, how do I do this?
--
Thanks
Slohcin