Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |