Sorting and selection question

[FotS]

Hi,

Just a simple question. I've done some searching here and on Google and haven't found my answer yet.

Is it possible to (given a selected cell), sort a range of cells that contains the selection and then have the selection move to stay with the original selected cell's data, without having to re-search the whole range for the original data?

 

[FotS]

Bump from page 15 :P

 

[VoG]

Try post #5 http://www.mrexcel.com/forum/showthread.php?t=549919

 

[FotS]

Excellent, that works. Thank you!