Activecell.offset next visible row

[Jaye7]

Hi,

I use the following script for activecell offset

activecell.offset(1,0).select

Can someone please provide a script that will work for a filtered list,
as at the moment when I use the script it is offsetting to invisble rows.

 

[pbornemeier]

Sub ArrowDown()
    SendKeys "{DOWN}"
End Sub

You cannot step through this command in the VBA editor - it will send the down arrow keystroke to the VBA editor.

 

[Jaye7]

Thanks for the script, just what I was after.