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! 😊