In the formula that you want to copy, insert a dollar sign before the
row numbers and/or column letters that you want to remain constant
before copying and pasting


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=546182