ExcelBanter - True Absolute Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - True Absolute Reference (https://www.excelbanter.com/excel-discussion-misc-queries/183695-true-absolute-reference.html)

[email protected]

True Absolute Reference

Hi,

When I insert columns I have to redo all my formulas. I understand
you can use indirect but I don't think it will work.

My formula is a simple =$E$20-$G$20, when I insert two columns it
becomes =$G$20-$I$20. How do I force it to keep the original cell
addresses?

Many thanks!

T. Valko

True Absolute Reference

INDIRECT will work:

=INDIRECT("E20")-INDIRECT("G20")

--
Biff
Microsoft Excel MVP

wrote in message
...
Hi,

When I insert columns I have to redo all my formulas. I understand
you can use indirect but I don't think it will work.

My formula is a simple =$E$20-$G$20, when I insert two columns it
becomes =$G$20-$I$20. How do I force it to keep the original cell
addresses?

Many thanks!

[email protected]

True Absolute Reference

THANK YOU!!!! Just cut down processing changes from 20 minutes to 2,
now I'm working on getting it down to 20 seconds.

T. Valko

True Absolute Reference

You're welcome!

--
Biff
Microsoft Excel MVP

wrote in message
...
THANK YOU!!!! Just cut down processing changes from 20 minutes to 2,
now I'm working on getting it down to 20 seconds.

All times are GMT +1. The time now is 10:30 AM.