=INDIRECT("D12")

--
Tim Zych
SF, CA

"Berkeley Brett" wrote in message
...
Suppose I set one cell equal to another -- say, in cell A3, I put

=D12

Now, cell A3 will be set equal to whatever is in D12, with whatever
formatting adjustments there may be.

Now here's my problem....

If I INSERT a cell ABOVE D12, pushing the contents of D12 down to cell
D13, Excel adjusts the formula in cell A3 to

=D13

Excel changes the formula in an attempt to help me out. Often enough,
this is a helpful thing. But sometimes it isn't!

What if I want cell A3 to be set equal to whatever is in the EXACT
cell D12, regardless of whether any cells have been inserted above
it? Is there a way to anchor the reference to EXACTLY a specific
cell?

Thanks in advance for any help you may have!

P.S.

=$D$12 isn't what I'm looking for. That anchors in a different way,
not the way I'm seeking.

--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites