VBA code to get the count of visible rows after filter

[sandu1]

Hellp Guys,

I am trying to find a code that will return the count of visible rows after using autofilter.

I actually want to place the return value on a cell. Example: if the no of rows visible if 64 on Sheet1 and I want to place the value "64" on Cell B1 on Sheet2.

Please let me know if its possible

Thanks

[sanram]

Try this :

Please Login or Register  to view this content.

[sandu1]

Thanks for the prompt reply.
Sorry, I forgot to tell you the Sheet names. Sheet1 is named as Stock-in and Sheet2 as "Avail"

So, I modified your code as below.

Please Login or Register  to view this content.

I get an error: Subscript out of range. Please correct me

[sanram]

Your code is correct. Can you upload a small sample?

[Alf]

Have you tried

Please Login or Register  to view this content.

was a but unsure what you wanted but rereading I assume you wish to find the number of visible rows so I've change formula function number from 9 (will give you sum of visible rows) to 103 that counts the number of visible rows.

Alf