Hey guys I am trying to write a macro to calculate something.
But I need to use variables.

I have tried:

ActiveCell.FormulaR1C1 = "=SUM(R[x]C:R[y]C)"

where x and y are integer variables but it doesn't register this.
Does anyone know how I can do this?


--
jnasr00
------------------------------------------------------------------------
jnasr00's Profile: http://www.excelforum.com/member.php...o&userid=28515
View this thread: http://www.excelforum.com/showthread...hreadid=501906