That didn't take long. Realizing I can have a "range" variable,
makes this method easy, though I could have simply saved the row and
col as well.
Your method is sort of "brute" force. I was hoping I could use a
built-in method to capture the cell after the value changed, but
before the selection changed. That's what the _Change event claims
to do...
I did something similar to keep the same cell selected after doing a
sort on a complex data field I saved the column and contents, then
stuffed a never-to-be-encountered garbage-key text into the cell,
then scanned for that garbage after the sort and replaced the real
contents. Perhaps crude, but it keeps the same cell selected after
the sort. P.S. If the selection was in the sort-key column, I picked
an adjacent column so the garbage wouldn't muck up the sort. It sure
is neat when the stuff you figure out works.