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!

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!

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!
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1