Welcome to the portion of my website where I share and store information or tools about Microsoft Access and Excel. Hope you find some of it interesting or helpful!
If you're totally new to using Microsoft Access, I recommend reading this article to help get you started.
If you have any questions or suggestions for the articles on the website, feel free to post in the forums. I can't promise my response will be quick, but I will try my best to respond to all forums posts.
Sincerely,
Azli
As an Amazon Associate I earn from qualifying purchases.
Here's some Excel VBA code that allows you to 'move' down (i.e. select/activate) a single visible row (or multiple if you adjust to code) that takes into account hidden or filtered rows.
Sub sMoveDown1Row()
'Select row to start on
.Range("A1").Select
'Go down 1 row
ActiveCell.Offset(1, 0).Select
'Keep going until on a row that isn't hidden
Do Until ActiveCell.EntireRow.Hidden = False
ActiveCell.Offset(1, 0).Select
Loop
End Sub