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

(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
        Loop

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 *