Hi,

Here's my situation :

I've filtered my data using the 2nd column in excel(2003). I want to count the number of rows. It's 154 in total but after filtering it should reduce. But I'm not able to get the exact count. can anyone help me with this?

Thanks
Justin

Hi Justin,

using VBA or just when manually applying an autofilter?

When you've applied it manually it shoul be displayed in the statusbar how many records were affected..

When using VBA you could count the number of visible fields in the first column (minus 1 for the columnheader):
e.g. ActiveSheet.AutoFilter.Range.Columns(1).SpecialCel ls(xlCellTypeVisible).Count

Hope this helps

Hi Disel,

Thanks for the reply. However, it throws me this error when I try to run it:

Run-time error '438':
Object doesn't support this property or method

Thanks
Justin

How about this?

http://www.contextures.com/xlautofilter03.html#Count

__________________
Regards,
JP
JP SoftTech

Thanks JP... It really helps...