I want to select cells within filtered cells.
Example
This is my code
Sub GoToNextVisibleCellBelow()
Do
ActiveCell.Offset(1, 0).Select
Loop While ActiveCell.EntireRow.Hidden = True
End Sub
It goes down 1 column within the column I selected. I can run this code as many times as necessary for more. However, as seen in the picture, although I could move left and right in the filtered cells, I could not select upwards.
What should I do to select an area like in the picture?
New contributor
abdul canbaz is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.