Count rows visible in filtered table

[drop05]

Hello, I have a table, table name "Reports" it is filtered in column J, and i am trying to get a count of just those rows that are visible but i am getting a high number like if it counting more than just what is visible,

Is there a specific vba method to get this count, i tried using the below but it is not getting the right output
wsAG is the worksheet, but maybe i should use the table name?
Thank you in advance!

Rowz = wsAG.AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible).Cells.Count - 1

 

[HaHoBe]

Hi drop05,

maybe try

Rowz = wsAG.ListObjects("Reports").DataBodyRange.Columns(1).SpecialCells(xlCellTypeVisible).Count

Ciao,
Holger