Hello, I was wondering if anyone knew how to autofit all of the columns once the 'OK' button is clicked on my userform?
Thanks in advance!
Hello, I was wondering if anyone knew how to autofit all of the columns once the 'OK' button is clicked on my userform?
Thanks in advance!
Columns("W:AA").EntireColumn.AutoFit where w and aa are the columns that need to be autofit, you might need to designate the sheet that needs to be autofit, ie activesheet. or Sheets("Sheet1").
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks