by Sisyphus » Tue Apr 12, 2016 12:20 am
Let's say, your list has the values{F, C, E, B, A, D}
Let's say, the currently selected value is B, the 4th value in the list.
Record the value B, not the row 4.
Now you sort the list and obtain {A, B, C, D, E, F}
In this list you look for B, which you find in row 2.
I suppose this could be done using formulas, but using VBA will be a lot easier.
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)