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