Count rows of a filtered range

Hi

I have the following code that filters and then counts the number of visible rows.

My problem is that the original list has 402 rows but after filtering has 79 rows. My code is giving me 1520 rows! there must be something I am doing wrong and any advice on what it is would be great.

Please Login or Register  to view this content.

I don't understand your filter?

Seems to be:

Please Login or Register  to view this content.

I would say that involves Columns?

Yet you're counting rows?

Please Login or Register  to view this content.

Hi John

Thanks for replying. I have filtered a table of about 20 columns with only "Sales" in column 2. I need to know how many rows of records show after filtering.

Am I doing it wrong?

Your filter range is one row?

Hi again

Filter range is Column 2 ("Sales"). I suspect I haven't understood filtering code.

Does this help?

Please Login or Register  to view this content.