getting a runtime error on a line

[scott.s.fower]

what the code below is doing is it is counting the rows in a named range

then it is counting the number of visible cells in that range

the error comes when there are no visible cells in the range,

please advise on how to avoid this the solution should result in tt = 0 so the code will GoTo clear1

Please Login or Register  to view this content.

[Norie]

Why not use Application.CountIf with the same criteria as the filter?

That should give you the no of visible rows, which you can subtract from the total rows to find the hidden rows.