Hi
not what you want but why don't you put your totals cell at the top of
the column and use the following formula (if the total is stored in A1)
=SUM(OFFSET($A$2,0,0,COUNTA($A$2:$A$1000)))

Benefits:
- no macro required (as it would be for your specification)
- simple formulas

--
Regards
Frank Kabel
Frankfurt, Germany
"benosc" schrieb im Newsbeitrag
...
Hi

Excel 2002 - I want to be able to put figures into cells
going from top to bottom and have a "totals" cell at the
bottom of these. When I reach the last cell to insert a
figure I want another line to be automatically inserted
and the formula in the "totals" cell to take account of
that line insertion.

Is it possible anf if so how. Any Ideas

Regards