Quote Originally Posted by danovkos
f.e. if i filtered data and select a range it return count of all cell (hidden too)...how can i count only displayed cell?
try this
[VBA] statusLine = statusLine & "; Vis =" & .CountA(Target.SpecialCells(xlCellTypeVisible))
[/VBA]