Autosum when adding lines

Microsoft Office excel 2007 home & stude...
December 10, 2010 at 09:35:56
Specs: Windows XP
Hi,

I have created a grid on excel, with a macro to add lines within it. At the bottom of the grid is an autosum. However, whenever i add a line, the autosum will not add up the new line too. Is there anyway of doing this?


See More: Autosum when adding lines

Report •

#1
December 12, 2010 at 01:57:30
anyone?

Report •

#2
December 12, 2010 at 06:26:53
the autosum will not add up the new line

It's dependent on where in your sum range you insert the new row.

If it is above the first line in your range, then it will not sum correctly
If it is below the last line in your range, then it will not sum correctly

You must insert somewhere below the 1st row and above the last row.

MIKE

http://www.skeptic.com/


Report •

#3
December 12, 2010 at 09:14:17
Do a Google search on Dynamic Named Ranges.

When using a Named Range that dynamically adjust it's Refers To address, you can use the AutoSum on that Named Range and it will adjust for added/deleted rows.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question