Sunday, 30 December 2012
Restoring Columns/Rows & Auto-fitting on all Worksheets
'Restore Column and Row Width / Height to Standard
Sub Height_Width()
On Error Resume Next
ActiveSheet.Cells.RowHeight = 15.00
ActiveSheet.Cells.ColumnWidth = 8.43
End Sub
'AutoFit All Columns on ALL Worksheets
Private Sub AutoFitAllColumns()
Application.ScreenUpdating = False
Dim wkSt As String
Dim wkBk As Worksheet
wkSt = ActiveSheet.Name
For Each wkBk In ActiveWorkbook.Worksheets
On Error Resume Next
wkBk.Activate
Cells.EntireColumn.AutoFit
Next wkBk
Sheets(wkSt).Select
Application.ScreenUpdating = True
End Sub
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment