@ symbol appearing in formula pasted by VBA

[Peaslake]

Hi guys,

I'm pasting the formula below into an excel sheet as part of a VBA routine,

Range("AJ9").Select
ActiveCell.FormulaR1C1 = "=IF(RIGHT(Y9,1)="">"" , ""NEW ILC"" , ""exist"")"

but what actually gets pasted into cell AJ9 is

=IF(RIGHT(@'Y9',1)=">", "NEW ILC", "exist")

as you can see - Y9 has become @'Y9 - it's driving me a little nuts as I can normally winkle out these errors

I hope you can assist.

thanks folks,
Stu

 

[jasonb75]

You're using .FormulaR1C1 so Y9 is not a valid cell reference.

 

[Peaslake]

You're using .FormulaR1C1 so Y9 is not a valid cell reference.

Thank you Jason, nailed it in one. Thanks for taking the time to answer.

all the best,
Stuart