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:
  1. Dim rngFilter As Range
  2.     Set rngFilter = Activesheet.AutoFilter.Range
  3.     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)?