hidden cells?

D

Dave Peterson

Depends on how they were hidden...

You can unhide a column. You can unhide a row. You can change the from from
";;;" to General. You can change the font/fill color to something that's
visible. You may have to play with format|conditional formatting.

If you mean hidden fields like MSWord has, then excel doesn't support showing
tabs, paragraph, space characters this way.
 
D

Don Guillett

does this work?

Sub togglehiddencolumns()
Range("a1,d1,f1").EntireColumn.Hidden = Not _
Range("a1,d1,f1").EntireColumn.Hidden
End Sub
 
Top