sum format
 

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?

sum format
 

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

sum format
 

When the information is all calculated i need the formulas left on the
worksheet so if i need to change any of the figures after the information is
inputted i can recalculate the totals.

"Dave Peterson" wrote:

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

sum format
 

Data|Subtotal inserts formulas that look like =subtotal().

If you insert/delete rows, you may need to remove the subtotals and reapply.
But that would apply to the macro code, too.

enyaw wrote:

When the information is all calculated i need the formulas left on the
worksheet so if i need to change any of the figures after the information is
inputted i can recalculate the totals.

"Dave Peterson" wrote:

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


--

Dave Peterson