when autofiltering a spreadsheet need to know number of records
 

when autofiltering the spreadsheet it doesn't calculate from how many record
it found how many record like a normal auto filter does.

when autofiltering a spreadsheet need to know number of records
 

I don't understand the stated question but have a look in the help index for
SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fouzia" wrote in message
...
when autofiltering the spreadsheet it doesn't calculate from how many
record
it found how many record like a normal auto filter does.

when autofiltering a spreadsheet need to know number of records
 

You mean the value returned in the statusbar?

http://contextures.com/xlautofilter02.html#Count
(From Debra Dalgleish's site.)

Fouzia wrote:

when autofiltering the spreadsheet it doesn't calculate from how many record
it found how many record like a normal auto filter does.

--

Dave Peterson