If I understand your question correctly, you could use absolute
referencing.

Modify the references within the Cells from A10 to $A$10. This
"stickies" the reference and you can copy the formula anywhere and the
references will remain the same.

You could also do $A10 or A$10 so that either the column or row
references become absolute when you copy.

Hope this helps.


--
ronlim
------------------------------------------------------------------------
ronlim's Profile: http://www.excelforum.com/member.php...o&userid=35738
View this thread: http://www.excelforum.com/showthread...hreadid=555216