Hi Héctor,

The formula does what you said. Too bad a recalulation is required.

By the way, I didn't understand what you said about using conditional
format to hide the row. And what is "bth" at the end?

Thanks!

Dave


"Héctor Miguel" wrote:

hi, David !

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 todetect a hidden column, I'll probably use conditional formatting to makethe cell turn red to warn me.)...

it's just a wild idea... if you can use a 'helper row', let's say: row 1 ?

[A1] =cell("width",a1) <- copy this formula up to cell 'G1'

now, use in the 'warning-cell'... - =countif(a1:g1,"<1")

one 'condition'... a re-calculation of your model is needed in order to update the 'warning-cell' :-(

you could use conditional format to 'hide' [A1:G1]... hide the entire row... or ???

Huh?

as I said, it's just a wild idea, but -I guess- you can 'handle' -almost-hidden columns :-)

What's an "almost-hidden" column?

hth,
hector.


--
Please delete "ANTI-SPAM" from email address
David Godinger: Go player, student of Mahatma Gandhi, the Buddha, and Dr. Martin King