# Fixed grid reference, possible?

1. ## Fixed grid reference, possible?

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!  Register To Reply

2. ## Re: Fixed grid reference, possible? correction

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!  Register To Reply

3. ## Re: Fixed grid reference, possible?

Use the INDIRECT function. E.g.,

=INDIRECT("A2")

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

"Beta" <beta@private.000> wrote in message
news:6QcEd.8693\$wZ2.5117@newssvr13.news.prodigy.com...
>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!
>  Register To Reply