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

dim X as long
dim Y as Long

x = 6
y = 7

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

======
Probably better to declare x and y as longs (not integers).

jnasr00 wrote:

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

--

Dave Peterson