Fixed grid reference, possible?

[Beta]

I have an application where I need to point absolutely to a fixed cell and
even if the content of that cell gets moved, still the pointer remains on
that cell. As an example suppose I have 1 in the cell A1. Now in the cell A2
I write =$A$1. Of course a 1 is the content of A2. But if now I drag the
content of A1 to B1 the cell A2 now points to =$B$1. What I'm looking for is
a way to have A2 still point at $A$2.
Thanks!

[Beta]

I have an application where I need to point absolutely to a fixed cell and
even if the content of that cell gets moved, still the pointer remains on
that cell. As an example suppose I have 1 in the cell A1. Now in the cell A2
I write =$A$1. Of course a 1 is the content of A2. But if now I drag the
content of A1 to B1 the cell A2 now points to =$B$1. What I'm looking for is
a way to have A2 still point at $A$1.
Thanks!

[Chip Pearson]

Use the INDIRECT function. E.g.,

=INDIRECT("A2")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Beta" <[email protected]> wrote in message
news:[email protected]...
>I have an application where I need to point absolutely to a
>fixed cell and even if the content of that cell gets moved,
>still the pointer remains on that cell. As an example suppose I
>have 1 in the cell A1. Now in the cell A2 I write =$A$1. Of
>course a 1 is the content of A2. But if now I drag the content
>of A1 to B1 the cell A2 now points to =$B$1. What I'm looking
>for is a way to have A2 still point at $A$2.
> Thanks!
>