Hi
Try
rylo![]()
Sub FitNow() 'Autofit main columns of workbook Dim i, j As Integer j = Sheets.Count For i = 1 To j ActiveWorkbook.Sheets(i).Columns("A:H").EntireColumn.AutoFit Next End Sub
Hi
Try
rylo![]()
Sub FitNow() 'Autofit main columns of workbook Dim i, j As Integer j = Sheets.Count For i = 1 To j ActiveWorkbook.Sheets(i).Columns("A:H").EntireColumn.AutoFit Next End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks