Previously active cell reference

[ETID]

How do I capture the cell reference of the previously active cell?

In a macro that launches on an event, either (change or selection)

If the active cell is C3 and I press "Arrow", "Tab" or "Enter", I want to be able to pick up the "C3" cell ref. of the cell that I just moved from.

 

[RobBroekhuis]

There's probably a better way, but here's one possibility - since you already use a Worksheet_SelectionChange event handler, you could have a static variable that holds the last active cell, by putting at the end of that event handler:

LastAddress=target.address

Then you can refer to the LastAddress variable when you need to return to the previous cell.
Rob