You may also want to consider using $ in the formulae. A $ prefix fixes
that part of the cell reference

so a formula of =$A$10 will copy and paste (or drag) as $A$10.
Whereas =A$10 will go to B$10 C$10 etc
and
=$A10 will go to $A11 $A12 etc

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=547106