Workbook Formats?

[Lime]

Hello,
I have a large wookbook with many worksheets. Is there any code that I could
use that would auto fit all the columns in the entire workbook? Any help is
always greatly appreacited..

 

[Luke M]

Sub AutoFit()
Application.ScreenUpdating = False
For Each ws In Worksheets
Cells.Select
Cells.EntireColumn.AutoFit
Range("A1").Select
Next
Application.ScreenUpdating = True
End Sub

 

[Jacob Skaria]

Try the below

Sub Macro4()
For Each ws In Worksheets
ws.Columns.AutoFit
Next
End Sub

If this post helps click Yes

 

[Lime]

Thanks for your help.. that did it..

Try the below

Sub Macro4()
For Each ws In Worksheets
ws.Columns.AutoFit
Next
End Sub

If this post helps click Yes