Autohide & Variables

[JaymzVXR]

Hi!

Love this forums, its been a great help in the past as reference but first time I've needed to ask something that wasn't already available.

Ive a spreadsheet of data with headers and only some of the cells are filled. These are filled with numbers which represent processes.

I'm trying to create a macro that if in B1 you enter 1,2, etc. it will show the columns that include these numbers but hide the others. I've tried this but had no such luck

Private Sub Worksheet_Change(ByVal Target As Range)
Columns("C:AG").Hidden = Range("B1").Value = "06"
End Sub


Thanks in advance!

 

[fibonacci1101]

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row = 1 And Target.Column = 2 Then
        Columns.Hidden = False
        Columns(Target.Value).Hidden = True
    End If
End Sub