Hi
one brute-force way would be to use the SelectionChange event to store the
old active cell in a static variable. what are you trying to do with this
information

--
Regards
Frank Kabel
Frankfurt, Germany
"MVM" schrieb im Newsbeitrag
...
How to find the location of the previous activecell?
Appreciate the help.
MVM