Hide a column when cell 12 that row is empty

[StanAalbers]

Hello there,

I have browsed the forum, but haven't found an answer yet for my challenge:

I have a sheet where the data starts in row 12. Whenever the value in that cell (a12, b12, c12, and so forth) is zero, I would like the column to be hidden.

I would like to have it in VBA, since this is a template with 84 columns across that is populated with different analyses every time.

Thanks in advance for your assistance.

 

[RJPotts]

Hello there,

I have browsed the forum, but haven't found an answer yet for my challenge:

I have a sheet where the data starts in row 12. Whenever the value in that cell (a12, b12, c12, and so forth) is zero, I would like the column to be hidden.

I would like to have it in VBA, since this is a template with 84 columns across that is populated with different analyses every time.

Thanks in advance for your assistance.

Sub Hide_Columns()
Dim cell As Range
For Each cell In Range("A12:CF12")
If cell.Value = "0" Then
cell.EntireColumn.Hidden = True
End If
Next
End Sub

& to unhide;

Sub UnHide_Columns()
Columns("A:CF").Select
Selection.EntireColumn.Hidden = False
End Sub

Rgds
Richard