It isn't, but it is the only way (at least that I know of).

What specifically is not flexible about it, there may some tweaks to use?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"T De Villiers"
wrote in message
news:T.De.Villiers.2aipgz_1152179104.2158@excelfor um-nospam.com...

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