Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling vertically filtered list
Hi,
Often I need to scroll vertically a list (typically activecell.offset(1,0).select type of statement) However, most often my list is filtered, and I would like the macro to jump to only the "visible" cells. Obviously OFFSET is then not the best way to accomplish because it goes through all rows regardless of whether it is visible or invisible (filtered out). What is the way to make a macro scroll from one visible row to another visible row? Many thanks in anticipation. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling vertically filtered list
Just looping through them looking for a visible row is one way.
Option Explicit Sub testme01() Do ActiveCell.Offset(1, 0).Select If ActiveCell.EntireRow.Hidden = False Then Exit Do Else 'keep looking End If Loop MsgBox ActiveCell.Address End Sub DKS wrote: Hi, Often I need to scroll vertically a list (typically activecell.offset(1,0).select type of statement) However, most often my list is filtered, and I would like the macro to jump to only the "visible" cells. Obviously OFFSET is then not the best way to accomplish because it goes through all rows regardless of whether it is visible or invisible (filtered out). What is the way to make a macro scroll from one visible row to another visible row? Many thanks in anticipation. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling vertically filtered list
Have a look in the vba help index for SPECIALCELLS
-- Don Guillett SalesAid Software "DKS" wrote in message ... Hi, Often I need to scroll vertically a list (typically activecell.offset(1,0).select type of statement) However, most often my list is filtered, and I would like the macro to jump to only the "visible" cells. Obviously OFFSET is then not the best way to accomplish because it goes through all rows regardless of whether it is visible or invisible (filtered out). What is the way to make a macro scroll from one visible row to another visible row? Many thanks in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup values vertically in a list and return the repeats | Excel Worksheet Functions | |||
Scrolling one pane only in a vertically split worksheet | Excel Discussion (Misc queries) | |||
Scrolling with two worksheets arranged vertically | Excel Discussion (Misc queries) | |||
How do you convert a list that runs vertically to horizoontally? | Excel Discussion (Misc queries) |