Is a "real" absolute reference possible?

[fdea]

Is it possible to insert a "real" absolute reference? I'm not talking
about things like $B$2. I would like my reference to be to cell B2 no
matter how many cells, rows, or columns I insert/delete, etc. In other
words, I do not want my reference updated when insertion or deletion
happens. It seems like Excel does this automatically and there is no
way to shut it off.

Can anyone help?

Thanks,


Frank



------------------------------------------------




------------------------------------------------

 

[Dave Peterson]

How about:

=indirect("b2")

Is it possible to insert a "real" absolute reference? I'm not talking
about things like $B$2. I would like my reference to be to cell B2 no
matter how many cells, rows, or columns I insert/delete, etc. In other
words, I do not want my reference updated when insertion or deletion
happens. It seems like Excel does this automatically and there is no
way to shut it off.

Can anyone help?

Thanks,

Frank

------------------------------------------------




------------------------------------------------

 

[fdea]

Dave,

Yeeeeeeeesssssssss!

Just what I was looking for.

Thanks Dave!


Frank



------------------------------------------------




------------------------------------------------