I have a combo box in which jan-dec are the input range and cell d301
is the cell link. I like to use a vba code to view only the month
selected.
This is what I have so far but it's not working.
The combo box is assigned to the following macro. (intended to show
columnw H and I=jan)
If d301 = 1 Then
Columns("j:ae").Select
Selection.EntireColumn.Hidden = True
End If
Thanks,
Jin