Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Mona Mehta   on Mar 02 In MS Office Category.

  
Question Answered By: Jaime Bowman   on Mar 02

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.

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Retain cell selection through sort Or get search suggestion and latest updates.


Tagged: