Your method retains selection of an absolute cell
location. I want the selection to follow the *contents* not stay at
the same the location.
What I want:
If the *contents* of cell C20 is moved, by a sort, to location C40, I
want cell C40 to be selected after the sort.
I'm still thinkin' I can save a "bread crumb" (some unique data)in
any unused cell in the same row. The column doessn't change in the
sort. Then, after the sort, search for the bread crumb to find the
moved row... All I need to learn is how to search a column in a
macro. Sounds slow, but effective.
Thanks anyway, it may come in usefull elsewhere.