I don't think you can, you need VBA.

This is a UDF that can do it

Function RowIsHidden(rng As Range)
If Rng.Rows.Count = 1Then
RowIsHidden = rng.Row.Hidden
End If
End Function

and use like

=RowIsHidden(H10)

--
__________________________________
HTH

Bob

"Ray" wrote in message
...
Hi
Using only worksheet functions, how do I find out if a row is hidden?
Thanks.