AutoFit All Rows and Columns on Multiple Sheets with VBA

In this tutorial, we delve into the world of Excel automation using VBA to streamline your workflow. Learn how to create a VBA macro to AutoFit all rows and columns across multiple sheets in a workbook. This time-saving solution ensures that your data is presented neatly and consistently. Follow along as we guide you step by step through the VBA code creation and demonstrate how to assign the macro to a button for quick execution. Enhance your Excel skills and efficiency with this powerful automation technique!

The Code used:
Sub AutoFitAllSheets()
Dim ws As Worksheet

Application.ScreenUpdating = False

For Each ws In ThisWorkbook.Sheets
AutoFitColumnsAndRows ws
Next ws

Application.ScreenUpdating = True
End Sub

Sub AutoFitColumnsAndRows(ws As Worksheet)
ws.UsedRange.EntireColumn.AutoFit
ws.UsedRange.EntireRow.AutoFit
End Sub

——————————————————————————————
📫 Business inquiries: techandaiwithhelen@gmail.com
——————————————————————————————

Видео AutoFit All Rows and Columns on Multiple Sheets with VBA канала Tech and AI Insights