using variables in formulas

[Code Chaser]

I am trying to make the row number dependent on the "temp" variable. But I keep getting an error. How should I write the code so the it will run?

Thanks.


Dim Temp As Integer
Temp = ActiveSheet.Range("A1").End(xlDown).Row - 1
Range("I" & Temp + 1).Formula = "= sum(I3:I" & temp")"

 

[Norie]

Try this.

Dim Temp As Integer

    Temp = ActiveSheet.Range("A1").End(xlDown).Row - 1
    Range("I" & Temp + 1).Formula = "=sum(I3:I" & temp & ")"

 

[Code Chaser]

Thanks! That worked great!