counting only the visible rows

[ashish727]

How can I count the no. of rows of a selection which has some hidden rows...I want to count only the visible rows

[Andy Pope]

Please Login or Register  to view this content.

[ashish727]

thanks a lot !

[royUK]

Please take the time to mark your question solved in future.

[shg]

selection.specialcells(xlCellTypeVisible).rows.count

That will only count the number of rows in the first area if specialcells is disjoint, I think, Andy.

This works if Selection is not disjoint:

Please Login or Register  to view this content.

[Andy Pope]

shg you are completely correct. must have had a brain fart!

Please Login or Register  to view this content.