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.