Hi
try
cells(2,3).formulaR1C1 = "=R[-1]C*" & J
--
Regards
Frank Kabel
Frankfurt, Germany
"kptheop" schrieb im Newsbeitrag
...
I am trying to put the following into a cell:
cell(2,3) = "R[-1]c*J"
(where j has been previously defined in the macro)
But, I get an error message "application defined or object defined
error"
Any suggestions?
Thanks. :)
--
kptheop
---------------------------------------------------------------------
---
kptheop's Profile:
http://www.excelforum.com/member.php...o&userid=15626
View this thread:
http://www.excelforum.com/showthread...hreadid=271705