Tareget Change Event

[seenfresh]

I am trying to grasp the concept of Worksheet_Change(ByVal Target As Range) Event

I am desiring to autosize columns B:I if cell A101 changes... But A101 holds a Data Validation list! can this still be achieved?

Any advice would be awesome!

Thanks in advance,

 

[Jonmo1]

yes, it works for me anyway.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$101" Then
    Columns("B:I").EntireColumn.AutoFit
End If
End Sub

 

[seenfresh]

Thanks Jonmo!

Works great!

Jonmo I have actually just experienced a weird problem... I have subtotals running with hidding detail below each subtotal... when I hide the detail the subtotal reads $0. When I unhide the detail the subtotal then calculates!!

I have never experienced this before... Have you?

Thanks again!