Is the current table row hidden by a filter?

[Jephph]

I'm a new member but I've been finding answers to my questions often on this board. Thank you for all your help!

I have some VBA code that runs through each row of a table and copies the content of the row into a form then prints the form to PDF (thereby making a PDF for each record in the table. This works great if I want to print everything, but I also need to allow the user to filter and then just process what is visible.

I'd like to be able to assign the visibility of the current row to a boolean variable.

Here's a simplified version of my code. I feel like I'm so close yet so far away.

Dim Vis as Boolean

For x = 1 to RowCount
    Vis = Worksheets("Control Center").ListObjects("AllData").Rows(x).SpecialCells(xlCellTypeVisible)
    If Vis = True Then
        'process the data and print'
    End If
Next

 

[Jephph]

I kept digging and found the answer to my own question. Here's my code...

            'If RowHeight is 0 the row is hidden
            RHeight = Range("AllData[Last Name]").Cells(x).RowHeight
            
            If RHeight = 0 Then
                ToPrint = False
            Else
                ToPrint = True
            End If