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).Co unt - 1 & " of " &
rng.Rows.Count - 1 & " Records"


--


Gary


"Tom Ogilvy" wrote in message
...
No, if Excel has control of the statusbar, then Application.Statusbar returns
false, not the message.

--
regards,
Tom Ogilvy


"Gary Keramidas" wrote:

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.

--


Gary