Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jaymz Brown   on Oct 11 In MS Office Category.

  
Question Answered By: Eline Bakker   on Oct 11

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.

Share: 

 

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

 
Didn't find what you were looking for? Find more on Capturing a change BEFORE leaving a cell Or get search suggestion and latest updates.


Tagged: