View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default 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.