Thread
:
Scrolling vertically filtered list
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett