Is a "real" absolute reference possible?

  • Thread starter Thread starter fdea
  • Start date Start date
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



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




------------------------------------------------
 
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...
 
Dave,

Yeeeeeeeesssssssss!

Just what I was looking for.

Thanks Dave!


Frank



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




------------------------------------------------
 
Back
Top