Sum formula in Excel

[Edleets]

Hi, I need help with a formula in VBA for "sum" but with a dinamic range, not fixed. For example If I know the "first row" and the "lastrow", what is the syntax of the code (not using R1C1) using for instance Range("A2").formula = "=........" Thanks

 

[jim may]

LR = 5
Range("B1").Formula = "=SUM(A1:A" & LR & ")"

 

[Marcelo Branco]

For example, say you want to sum a range in column B.

Try

Range("A2").Formula = "=SUM(B" & firstRow & ":B" & lastRow & ")"

M.