Use SUBTOTAL(2,rng)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pieter" wrote in message
...
I want to count the number of rows i a worksheet. I have hidden the non
relevant rows in the sheet.