application.subtotal(3,range("A1:A100"))

as an example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"x taol" wrote in message
...


i want to count the filtering data in using autofilter with vba.

*** Sent via Developersdex http://www.developersdex.com ***