Hi guys,
Now, from D2 to the end of the col D, I created a drop down list with 2 option Yes or No. when I choose Yes, the col I will be hided. When I choose No, the col I will be unhided.
My code is below:
How I change target from D2 to the end of the col D?Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 4 And Target.Row = 2 Then If Target.Value = "No" Then Application.Columns("I").Select Application.Selection.EntireColumn.Hidden = True ElseIf Target.Value = "Yes" Then Application.Columns("I").Select Application.Selection.EntireColumn.Hidden = False End If End If End Sub
And how auto unhided the col I when the option No is changed Yes?
Thanks a lot!
Bookmarks