selection of cell after autofilter

S

sclarke

Sometimes when I perform an autofilter, the current active cell is hidden and I have to select a new cell or use the arrow up or down key to see where I am in the list. Is there a way to have the top cell in the current autofiltered list be the currently selected active cell? Maybe a VB macro in Worksheet_Change or Worksheet_SelectionChange Event ?
 
D

Dave Peterson

I just click on the header for that column and then use the down arrow from the
keyboard.

With windows|Freeze panes in use, I get the first visible row in the autofilter
range.
 
Top