Jump to content

Build Theme!
  • Infected?


Hey there! :wub: Looks like you're enjoying the discussion, but you're not signed up for an account. When you create an account, we remember exactly what you've read, so you always come right back where you left off. You also get notifications, here and via email, whenever new posts are made. You can like posts to share the love. :D Join 92768 other members! Anybody can ask, anybody can answer. Consistently helpful members may be invited to become staff. Here's how it works. Virus cleanup? Start here -> Malware Removal Forum.

Try What the Tech -- It's free!


excel vba sorting while following selected cell

excel 2007 vba sort select selection find

  • Please log in to reply
No replies to this topic

#1 K e n

K e n

    New Member

  • Authentic Member
  • Pip
  • 11 posts

Posted 02 June 2014 - 05:12 AM

Hallo again.


I can't locate any material on the following:


Situation: excel worksheet with c. 5 columns and 500 rows; activated modal user_form with code causing a re-sorting of the rows.

Aim: note the data set containing the selected cells (the cell-values__not the range) and return the selection to the data set's new range after the sorting procedure is completed.


Have workaround in place involving populating an additional cell in the column outside the functional sorting range with a unique value. This is then searched for and selected after the sorting. Works in principle, but is clumsy and leaves lots of footprints in the debugging phase.


Anybody have a more elegant method? Possibly with greater flexibility ('cos I would like to be able to re-access any one of three opr four previously selected cells (again: content and not range.address)?


Thanks for reading this already.


K e n


Register to Remove

Related Topics

Also tagged with one or more of these keywords: excel 2007, vba, sort, select, selection, find

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users