Hidding a Column Using VB

Bre-x · Dec 11, 2003

Hi,

How do i hide a column depending of a value on a cell?

if mycell = 0 then hide column?

thnks

Bre-x

J.E. McGimpsey · Dec 11, 2003

one way:

With myCell
.EntireColumn.Hidden = (.Value = 0)
End With

Bre-x · Dec 11, 2003

thanks

J.E. McGimpsey said:
one way:

With myCell
.EntireColumn.Hidden = (.Value = 0)
End With