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
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