One way would be to have say a series of 1s in a column, eg lets assume
A2:A100, and then in cell A1 you were to use a formula such as

=SUM(A2:A100)-SUBTOTAL(109,A2:A100)

then any value in cell A1 other than 0 would indicate a hidden row within
that range.

You could also conditionally format cell A1 to flag up red or something if
that condition was met.

The 109 argument in the SUBTOTAL function is only available in Excel 2003
onwards.

Regards
Ken..............................



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