Mac Forum / Applications / Excel / November 2007

That looks about right, in that you can "hide" a row or column by
making it zero height/width.  It just doesn't bother to display
whatever you've hidden (but of course it is still there functionally,
so you can hide sensitive formulae if necessary).

As regards the rest of your question, an expert will come along
shortly... (I hope!)

PhilD

--
<><

In article
<1a55582f-145b-4753-acaa-e1a2cfb53a01@e25g2000prg.googlegroups.com>,

In the Excel Document Object Model (DOM), setting a range's Hidden
property (e.g, in VBA: Columns(1).Hidden = True) produces the same
result as setting the range's ColumnWidth property to 0.

Formatting, including conditional formatting, cannot change environment
variables like Height and Width.

It's easy, though to use a Event macro to change those settings. For
instance, if you want to hide a row if the value in column A is zero,
put this in your Worksheet code module (CTRL-click the worksheet tab and
choose View Code):

   Private Sub Worksheet_Change(ByVal Target As Excel.Range)
       Dim rCell As Range
       Application.ScreenUpdating = False
       For Each rCell In Range("A1:A" & _
                 Range("A" & Rows.Count).End(xlUp).Row)
           With rCell
               If IsNumeric(.Value) Then .EntireRow.Hidden = .Value = 0
           End With
       Next rCell
       Application.ScreenUpdating = True
   End Sub