Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect Hidden Columns by Formula
Hi,
Is there a formula that will notify me if any column(s) in a range are hidden? (I don't want to do this by VBA.) I want it to notify me by formula, if that's possible, because I need to know immediately if something is hidden. (Once I can understand how to detect a hidden column, I'll probably use conditional formatting to make the cell turn red to warn me.) The following formulas worked with rows, when the cells A2-A5 had values in them. However, I can't make them work by changing "ROWS" to "COLUMNS" and, for example, "A2:A5" to "A2:G2". When using a filter =2*ROWS(A2:A5)-(SUBTOTAL(3,A2:A5)+SUBTOTAL(103,A2:A5)) Without a filter =SUBTOTAL(3,A2:A5)-SUBTOTAL(103,A2:A5) (Credits to JMB for the formulas that worked with rows. See the thread with the subject. "Detect Hidden Rows by Formula.") Thanks, Dave -- Please delete "ANTI-SPAM" from email address David Godinger: Go player, student of Mahatma Gandhi, the Buddha, and Dr. Martin King |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detect Hidden Rows by Formula | Excel Programming | |||
vba to detect if column contains partially hidden text | Excel Programming | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
How to detect if a workbook is hidden through VBA | Excel Programming | |||
How to detect if sheet is hidden? | Excel Worksheet Functions |