Variable in an R1C1 formula
 

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 define
error"

Any suggestions?

Thanks. :

--
kptheo
-----------------------------------------------------------------------
kptheop's Profile: http://www.excelforum.com/member.php...fo&userid=1562
View this thread: http://www.excelforum.com/showthread.php?threadid=27170

Variable in an R1C1 formula
 

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