Auto Column Widths

  • Thread starter Thread starter keyser_Soze
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top