selection of cell after autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
Autofilter 10
Enabling Autofilter and Sorting in a Protected Sheet 2
Excel Macro to use cells as a autofilter 0
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
Placement of autofilter drop down menu? 6
MS Excel 2003 - Autofilter for protected cells 1
Center Autofilter buttons 2

Back
Top