I'm sure that there would be.

But is there a reason you don't want to use Data|Subtotals? It might be
sufficient and it's built into excel.

enyaw wrote:

Is there a way that i would be able to insert a row into a worksheet through
vba with a certain format and be able to summ all the rows above. Each time
i insert this row i want to be able to sum the values between it and the last
inserted row. Anyone know how to do this?

--

Dave Peterson