Detect Hidden Columns by Formula
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 ???
as I said, it's just a wild idea, but -I guess- you can 'handle' -almost-hidden columns :-)
hth,
hector.
|