VBA: how to enter this formula

[yky]

I need to calculate the sum of a range. It looks to me range.subtotal is the way to do it. The problem is I don't know how to use it. I did an Internet set but found no detailed instruction. The next thing I tried is to insert a "=sum" formula to a cell in a spreadsheet. I have a problem with this also. How do I do the following? Thanks.

[E65536].End(xlUp).Offset(3, 0).Formula = "=sum(E6:" & [E65536].End(xlUp) & ")"

 

[prajul89]

To get the row use this:

Range("E" & Rows.count).End(xlup).Row

I hope this should give an idea on what you are suppose to do!!

 

[prajul89]

This is how your formula would look like:

Range("E65536").End(xlUp).Offset(3, 0).Formula = "=sum(E6:E" & Range("E65536").End(xlUp).Row & ")"

 

[Marcelo Branco]

Or maybe this

[E65536].End(xlUp).Offset(3, 0).Formula = "=sum(E6:" & [E65536].End(xlUp).Address & ")"

M.

 

[mikerickson]

Or

[E65536].End(xlUp).Offset(3, 0).FormulaR1C1 = "=SUM(R6C:R[-3]C)"