I have a lengthy list (several thousand lines) with an AutoFilter. I've
received complaints from users that, when they filter the list, the cell they
had selected doesn't "travel" to the new location in the filtered list. If
active cell A11 contains, say, "turtle" before the sort, they want it to
contain "turtle" after a sort as well and to be visible in the window
(assumiing that "turtle" hasn't been hidden in the course of the sort). I've
explained that they just have to do a find, but this was met with a sort of
frozen displeasure I don't want to ever see again.

Is what they want possible? I'd like to think not, but is there a workaround
in VBA, perhaps?

I should probably clarify this: In the example below, the active cell doesn't
need to continue to be A11 after the sort. The active cell just needs to be
the one that contaiins "turtle," no matter where it ends up.

Sorry about the confusion!

"Michael Link" wrote:

I have a lengthy list (several thousand lines) with an AutoFilter. I've
received complaints from users that, when they filter the list, the cell they
had selected doesn't "travel" to the new location in the filtered list. If
active cell A11 contains, say, "turtle" before the sort, they want it to
contain "turtle" after a sort as well and to be visible in the window
(assumiing that "turtle" hasn't been hidden in the course of the sort). I've
explained that they just have to do a find, but this was met with a sort of
frozen displeasure I don't want to ever see again.

Is what they want possible? I'd like to think not, but is there a workaround
in VBA, perhaps?