[Excel] Find Matches In Autofilter Column

I have a list of Ids in a Column (as well as data in columns next to this).
I have auto-filtered that column and now I need to check for matches in that new filtered list.

I tried doing this but it doesn't return any matches

VB Code:

Dim rngFilter As Range
    Set rngFilter = Activesheet.AutoFilter.Range
    WorksheetFunction.CountIf(rngFilter.SpecialCells(xlCellTypeVisible).Columns(3), "123*")

It seems that rngFilter.SpecialCells(xlCellTypeVisible).Columns(3) is only returning one cell.
If I exclude the SpecialCells option I return values from excluded rows.
If I use EntireColumn it also returns values from excluded rows.

Any ideas (aside from writing my own method)?