I want to something like this:

ActiveCell.FormulaR1C1 = "=R1C&(offset+2)*RC[-4+x-2]"

(offset is some constant, and x is the var in for loop)

The VBA recorder gave me this:

ActiveCell.FormulaR1C1 = "=R1C7*RC[-4]"

What is the correct synatx to do this? Thank

--
McManCS
-----------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...fo&userid=2437
View this thread: http://www.excelforum.com/showthread.php?threadid=38013

ActiveCell.FormulaR1C1 = "=R1C" & offset+2 & "*RC" & -4+x-2

but you should be able to simply use x - 6 for the last argumen
instead of -4+x-

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38013