Count Displayed Rows of a Filtered Worksheet

[Norman Zhang]

I'm using XLS 2003, how can I get the total number of displayed rows of
a filtered worksheet?

E.g., The display rows would appear as

Row 1
Row 2
Row 10
Row 100
....

Norman

 

[Gord Dibben]

If you don't see xx of xxx records on the status bar go to Debra Dalglesih's
site for instructions.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben MS Excel MVP

 

[Don Guillett]

Look in the help index for SUBTOTAL and read it carefully