autofilter question

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

know how the status bar shows "x out y records found"? is there any way to
return the x value? i can count the rows, but excel already counted them and
just wondering if that can be captured.
 
ok, so is the only way to get a count of the filtered records is to use
something like your code?

MsgBox rng.Columns(22).SpecialCells(xlCellTypeVisible).Count - 1 & " of " &
rng.Rows.Count - 1 & " Records"
 
thanks

here's what i ended up using

sTotal = WorksheetFunction.Subtotal(103, Range("v24:V" & endrow))
 
Back
Top