Learn how to create a VBA Excel Macro from scratch. You'll learn how to access the VBA editor, type in some code, produce a useful macro, and link it to a button. In this case the macro will automatically resize the column widths so that your spreadsheet data fits perfectly in each column. See below for the VBA code for this macro. My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's the practice file that goes with this video: http://bit.ly/vbamacro1 #exceltutorial #excel
Books to help you make Excel VBA Macros:
Excel VBA Programming for Dummies: https://amzn.to/3piWIZ5
Excel Power Programming with VBA: https://amzn.to/3ph323p
VBA Automation for Excel: https://amzn.to/36cGPff
Here's the VBA code for this macro:
Sub AutoFitAllColumns()
Activate
Cells.Select
Cells.EntireColumn.AutoFit
End Sub