I'm not sure what you're asking, but I think that Absolute References are
what you are looking for, e.g., $A$1 instead of A1. See
http://www.cpearson.com/excel/relative.htm for more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"ajbanana" wrote in message
...
excel uses what technique to keep a cell reference constant when copying a
fomular or function