When a row has a value of FALSE I want to hide a column, when a row has a value of TRUE I want to display the column.
I have written the VBA to display columns with a value of TRUE (below).
How can I expand this to have one marco to do both? i.e. show true AND hide false
Dim a As Range
For Each a In Range("k3:ah3").Cells
If a.Value = True Then
a.EntireColumn.Hidden = False