Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to displayed row of filtered list
Hello Group,
If a list is filtered, can one move to the first displayed row after the header row ? Thanks, Michael Singmin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to displayed row of filtered list
Michael,
From a prior post by Tom Ogilvy...... John <snip Sub GetFirst() Dim rng As Range Set rng = ActiveSheet.AutoFilter.Range Set rng = rng.Offset(1, 0).Resize(, 1) _ .SpecialCells(xlVisible) Set rng = Intersect(rng(1, 1).EntireRow, _ ActiveSheet.AutoFilter.Range) rng.Select End Sub <snip Michael Singmin wrote: Hello Group, If a list is filtered, can one move to the first displayed row after the header row ? Thanks, Michael Singmin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get number of filtered records found displayed in a cell? | Excel Worksheet Functions | |||
Drop down list and what can be displayed. | Excel Discussion (Misc queries) | |||
filtered values can displayed in certain cell | Excel Worksheet Functions | |||
Be able to move not delete filtered records, to see the duplicats | Excel Worksheet Functions | |||
List box not being displayed in second worksheet | Excel Discussion (Misc queries) |