Hi,

In A1 I have formula sum(A3:A12), however when I insert a line in the
range,
the formula changes to sum(A4:A13), however I would like the formula to

stay the same.

An idea is sum(Indirect("A3:A12")), however this isnt very flexible.

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