Sort but then stay on the same entry

Excel 2010

I have a feeling that this should be easy but cannot work out how to do it. Since retiring 7 years ago I seem to have forgotten much of the VBA I use to know.

I have a sheet of several hundred tree species - one per row. Column C has the English name and D the Latin name. Other columns have other data. I can use a macro to sort by English name and another to sort by Latin name - no problem.

If the sheet is sorted by English name but then I want to change to sorting to by Latin name I want the same species to be selected after the sort is complete. At present the whole data range remains selected.

Do I have to read say the Latin name before running the sort, store it in a variable, and then use some type of find function to get back to the original row or is there a better way.

If I have to do a read and find as above some hints on the syntax to use would be useful.

AQ

Hi Anthraquinone and congratulations on your first post.

Try the following:
a. Get the cell location before you start the sort.
b. Get the contents of the other column that you want to go to after the sort is completed.
c. Sort
d. Find the cell that contains the value obtained in b. above and go to that cell.

The following code excerpt may help you with some of the above:

Please Login or Register  to view this content.

Lewis