Selecting top cell after auto filter procedure

R

rob nobel

On a wksheet where freeze panes occurs at row 25 and after running an auto
filter procedure in VBA....
What is the best method to activate the first row, Col N, in the visible
rows?

In another similar procedure,
2. How can you make as many of the visible rows visible so that the last
visible row is still viewable without having to manually scroll up or down?
( In other words, have the last visible row showing as low as possible on
the screen.)

Rob
 
Top