try this
ActiveCell.Formula = "=if(Countif($J:$J,E2)=1,E2,"""")"

--


Gary


"cooldyood" wrote in
message ...

ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"

My macro keeps throwing an error at this line. Is there an error in the
syntax here?


--
cooldyood
------------------------------------------------------------------------
cooldyood's Profile:
http://www.excelforum.com/member.php...o&userid=35611
View this thread: http://www.excelforum.com/showthread...hreadid=570597