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

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

thanks

here's what i ended up using

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

--


Gary


"Alok" wrote in message
...
Use formula

=Subtotal(3,A2:A50)
Here A2:A50 is the range that has been filtered.

Alok

"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

i used 103 & 109, i only want visible cells. it did what i needed

--


Gary


"Alok" wrote in message
...
Hi Gary,

Did you use 103 ? or is that a typo?

Alok

"Gary Keramidas" wrote:

thanks

here's what i ended up using

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

--


Gary


"Alok" wrote in message
...
Use formula

=Subtotal(3,A2:A50)
Here A2:A50 is the range that has been filtered.

Alok

"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