David McRitchie has one you could review at:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

T De Villiers wrote:

Hi, I need a macro whereby:

When I insert a line the formulae from the rows above are copied down,

Many Thanks

--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=475771

--

Dave Peterson