Why does this not work.
Selection.AutoFilter field:=AFCC, Criteria1:=Celsite
freqCnt = Selection.Application.Max(Columns(AFCF))
freqCnt = Application.Max(3, Columns(AFCF)).SpecialCells(xlCellTypeVisible)
the last two statements are my attempt to find the maximum value in a filtered range.
Everything I try comes up with an error
I want to know the maximum value in the visible cells for the column of my choosing after I filter the data.