K keyser_Soze Sep 29, 2005 #1 I would like columns n through v to auto size whenever any cell in those columns changes. How can I do this? Thanks.
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 Sep 29, 2005 #2 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
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
