(Solved) – How to select the next available cell when working with rows that hides and unhides as required


I’m currently putting together an interactive checklist for my team.

Depending on the cell value, rows will hide and unhide as required.

How do I get my spreadsheet to select the next visible cell down?

My current code is as follows:

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1, Criteria1:= _

        Selection.End(xlUp).Offset(1, 0).Select
        Do While ActiveCell.EntireRow.Hidden = True
            ActiveCell.Offset(1, 0).Select

Application.EnableEvents = True

End Sub

This code works fine if I were to type in the answer, however it jumps to the start if I were to select the value from a drop-down list.

Is there a way for me to set this so that the selected cell is always going to be the next unhidden cell down?

Many thanks for your help in advance! 😊

Leave a Reply

Your email address will not be published. Required fields are marked *