By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 219 - GetNextRow - filtering udf

Function GetNextRow()
Activecell.Offset(1,0).select

Do while Rows(Activecell.Row).Hidden

Activecell.Offset(1,0).select

Loop

GetNextRow = ActiveCell.row

End Function