Auto Column Widths

K

keyser_Soze

I would like columns n through v to auto size whenever any cell in
those columns changes. How can I do this?

Thanks.
 
K

keyser_Soze

I found this one.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("N:V")) Is Nothing Then
Target.EntireColumn.AutoFit
End If
End Sub
 
Top