you can lock the formula by adding dollar signs e.g
=a1+a2
if you move it it will change


=$a$1 + $a$2

will lock the formula

if you add only a $ in front of the column e.g $a1 then it will lock
the column only vice versa



good luck


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549407