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. |
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) |