Moving to the next cell that is not Hidden, VBA

[Andry143]

I have a large amount of data that I am doing an advanced filter on using VBA. When this data is sorted in place, several of the lines are Hidden according to the sorting criteria. I would like some code that would allow me to Step/Cursor to the next row that is not hidden. I tried the Offset function and it takes you to the next row regardless of whether it is hidden or not.

Example:

Row 3
Row 8
Row 11

I want the code to Activate Row 3 and then move to Row 8 without Activating Rows 4,5,6,7.

Thanks for the help.

 

[HalfAce]

Hello Andry143,
Without seeing your code it's a bit hard to be very specific but here's a quick little example
that may point you in the right direction.

Sub NextVisibleCell()
Dim Rng As Range, c As Range
Set Rng = Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row)

Columns("A:A").AutoFilter Field:=1, Criteria1:="xyz"
For Each c In Rng.SpecialCells(xlCellTypeVisible)
  MsgBox "The ActiveCell now is " & c.Address(0, 0)
Next
  
End Sub

If this doesn't help can you describe your situation in more detail?