Help Me Please - Sum Formula to work in Macro for Variable Length Data

[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!

 

[brad7989]

Would it help for me to post some of my data?