Have a look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JTP" wrote in message
...
once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been
filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!