Add Absolute reference to clipboard

[AhhSheets]

How do I get a macro to keep the absolute reference of active cells for use in a cell formula later? i.e. I have cell E11 selected, I want my macro to remember the value in cell E11 and the reference, then move to column A in the same row and make a formula that is = 18 - E11 (which should equal zero as it is a check figure taking the value of E at the time the macro was triggered less the current value displayed in E. I'm struggling to get it to identify the "E11" portion.

 

[Cubist]

How do I get a macro to keep the absolute reference of active cells for use in a cell formula later?

Store it in a variable and call it when you need it.