Take a look at the Indirect formula...

=INDIRECT("A1")
--
HTH...

Jim Thomlinson


"John P" wrote:

Hi. I have some Excel formulas that refer to some cells. When these cells are
moved, the formulas refer to the new cell position. How can I prevent this
from happening and have these formulas refer to the same cell position? I
have tried absolute cell reference but that does not help. Thanks