Hi Angela,
Glad to add something additional to help with Mike's solution.
I'm kind of partial to context menus as you might notice from
the related area at the bottom of that page for other applications
as well.
http://www.mvps.org/dmcritchie/excel/rightclick.htm

The reason for use of OFFSET is so that you can add or
delelet rows immediately before the total.
http://www.mvps.org/dmcritchie/excel/offset.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"J_Gold" wrote...
Hi David - Thanks! hadn't even thought of taking it that far - perfect
solution. ---Cheers, Angela