address of active cell at calc: =CELL("address")

contents: =INDIRECT(CELL("address"))


"ChrisR" wrote in message
...
|I want a given cell eg z100 to constantly - or at each recalculation - to
| hold the contents - or reference - of ActiveCell (so a text box can
highlight
| it.). My code does it but only once at each run of the module, then it
sticks
| or throws an error.