Hidden Row Detection

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select all (including hidden) rows in autofilter region 2
Detect Hidden Rows by Formula 8
Well, how hidden is it ?? 4
Rows hidden by Autofilter vs hidden by changing the Hidden property 4
Clear contents of cells hidden by autofilter 3
Testing/Finding .Hidden for Rows May21 10
Hidden text in tables causes empty rows 0
Named Range, hidden row, auto-filter & macro buttons 1

Back
Top