MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell entry for summing all above

Posted by Robin T on April 26, 2001 4:31 PM

I have a macro to insert a row and paste values into the new row.
This works. The problem is the sum range doesn't stay dynamic with the additional rows.
I know there is something very simple staring at me, but I can't see it.
I just wanted a simple =sum() in a cell.


Posted by robin t on April 26, 2001 5:23 PM

I got it. I got it. Just needed to walk away. Used range names.

Thanks for letting me blank out here.