SUM function help

[jnasr00]

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?

[Dave Peterson]

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