Not sure if you mean you want to place the total row each time, or if you
want the total row to move down and still work as you insert rows.

If you want the total row to move down then see my page
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
and pay attention to the requirement to use OFFSET.

---
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

"ForSale " wrote in message ...
I want there to be a 'total' row at the end of my workbook. the problem
is, the end of the workbook changes constantly. how can i make the
total row be where everything else stops?
thanks in advance


---
Message posted from http://www.ExcelForum.com/