* Question for Sum formula in Macro *

[brad7989]

I have data that comes in at variable lengths in terms of rows and want to have the macro insert a Totals row. The problem I have though is I can't get the sum formula to start from the top and go down through the bottom.

If you can help me with this, I'd greatly appreciate it!

Thanks!

 

[wigi]

Where will the sum formula be placed on the sheet?
Is row 1 a row for headers?

 

[brad7989]

Where will the sum formula be placed on the sheet?
Is row 1 a row for headers?

The sum formula will be paced at the bottom of the data list with one blank row separating the data from the sum cells.

Row 1-5 will be headers and the data will begin on row 6. That will be the same every time - it's just the lower end that will change.

 

[wigi]

For instance:

Sub putformula()
   Range("A" & Rows.Count).End(xlUp).Offset(2).Formula = "=SUBTOTAL(109,R6C:R[-2]C)"
End Sub

 

[brad7989]

Cool thanks.

Nice website by the way.

 

[wigi]

Cool thanks.

Nice website by the way.

Thank you too