Is a "real" absolute reference possible?

F

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



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




------------------------------------------------
 
D

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

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




------------------------------------------------
Click to expand...
 
F

fdea

Dave,

Yeeeeeeeesssssssss!

Just what I was looking for.

Thanks Dave!


Frank



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




------------------------------------------------
 
Top