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)?


Reply With Quote