Excel Macros

Configuring Excel for Macros The Developer Tab Macro Security Trust Center Saving Files Basic Macro Recording The “Record Macro” Window Rules for Macro Names Running Macros Running a Macro from the Developer Tab Running a Macro Using a Shortcut Key Running a Macro from a Button Running a Macro from a Worksheet Object Creating Dynamic Macros Absolute versus Relative References Effective Range Selection The Importance of the Cursor’s Position Handling Empty Cells in a Data Range Using Functions and Formulas in Macros Creating dynamic formulas Filling Formulas Using Data Tables Deleting Empty Rows at the End of a Worksheet Functions with Dynamic Ranges Working with Files The Personal Macro Workbook Using Hyperlinks Writing Macros that Work on Variable File Names Importing a Text File Macros for Data Entry Creating a worksheet to use as a Data Entry Form Creating a macro to add the data to a table