Simulate pressing down arrow key in VBA

[LeonardH]

Hello Everyone,

Working on code and it currently uses filters. I need to select the next cell down. This is different than an offset, because offsetting 1 row chooses the next row even if it is hidden. I need the next unhidden row of data just like I would be able to if I just pressed the down arrow key.

Thanks,

 

[LeonardH]

Or perhaps if someone is aware of a way to select all visible cells within range D6:E3743, that might be more helpful.

Thanks in advance everyone!

 

[MARK858]

1st question

ActiveCell.EntireColumn.SpecialCells(xlCellTypeVisible).Find(What:="*", After:=ActiveCell).Activate

2nd question

Sub xxx2()
Range("D6:E3743").SpecialCells(12).Select
End Sub