Excel - Create an Excel Macro from Scratch: AutoFit Columns

4.0 (5)

37 learners

What you'll learn

This course includes

39.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

vba macro vba macros creating vba macros vba macros in excel how to create an excel macro exel macro create excel macro create excel macro from scratch build excel macro excel macro coding excel vba vba basics

Full Transcript

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