Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not sure why you want to move to that first visible cell, but here's an example
to find the first visible cell in the first column of the autofilter range (not counting the header row). Option Explicit Sub testme01() Dim rngF As Range With ActiveSheet.AutoFilter.Range.Columns(1) Set rngF = .Resize(.Rows.Count - 1).Offset(1, 0) _ .Cells.SpecialCells(xlCellTypeVisible) End With MsgBox rngF.Cells(1).Address End Sub Tempy wrote: Could somebody please help me with the above, i am filtering with code but am not sure of the code to move to the first displayed cell. Les Stout *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Advanced Filter: How do you MOVE the selected rows... | Excel Worksheet Functions | |||
How do I move from cell A 10 to cell B1 with one move or click | Excel Worksheet Functions | |||
Excel - arrow keys move whole sheet instead of from cell to cell | Excel Discussion (Misc queries) | |||
arrow keys move entire sheet instead of cell to cell | Excel Worksheet Functions | |||
move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) |