Hidding a Column Using VB

[Bre-x]

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]

one way:

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

 

[Bre-x]

thanks

one way:

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