Neil,

Assuming that you don't want to get into VB code and the setting up of
buttons,
when you insert a new row, go to the row above, and, highlight all
cells that are formula, (hold the CTRL key and select all formula
cells), then drag the formula down a row (via drag the small square in
the bottom right of the highlight).

Hope this helps


Neil_Pattison Wrote:
Thanks bryan the problem with the formula is sorted now. Another problem
I have is when inserting a new row into the middle of the worksheet I
want the formula to automatically copy into the new row. How do I get
this to happen?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=472528