agreed it all to do with lock the cell by adding a '$'

for example...


$D$5 would lock the cell in a formula and no matter where you paste it
D5 would be linked.

D$5 would lock the row, so the column would alter in relation to it's
original position but not the row

$D5 would lock the column, so the row would alter in relation to it's
original position but not the column.



HTH


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=567500