Try looking at this thread:

http://tinyurl.com/3ht7y

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
Hi All
Is there a method using worksheet functions to detect if a
row is hidden?

I am using SUMIF(......) and want to place as part of the
condition of summing whether a row is hidden or not.

I can use Autofilter and Sub-Total to get this but I need
more than one conditional.

Cheers
Nigel