Hi,

Andy, Ken, Bob, thank-you for your replies.

The idea of using subtotal() was useful as I can indicate whether I want
hidden values to be included into the function.

Cheers,

Rayney

"Ray" wrote:

Hi
Using only worksheet functions, how do I find out if a row is hidden?
Thanks.