Recording Macros

Recording Macros

It is easy to create a recorded macro. It is not so easy to create a flexible and re-usable recorded macro. Learn the techniques that can allow you to record effective macros that can handle different ranges and changes to sheet names.


Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel.

Future sections will expand on the techniques taught in this section.


This section includes bonus macros that you can use straight away to save time and effort.

The Complete Macro Series

Buy nowLearn more

Recording tips, trick and traps

  • Recording Macros
  • Recorded Macros 2020 crashed completed.xlsm
  • Recorded Macros 2020.xlsm
  • Recorded Macros tips and tricks 2020.pdf
  • Macros1 Recording tips recording
  • Recording Macros Quiz

Recorded to Remarkable

  • Recorded to Remarkable
  • Recorded to Remarkable 2020.pdf
  • Recorded To Remarkable 2020.xlsm
  • Recorded To Remarkable 2020 completed.xlsm
  • Recorded to Remarkable recording
  • Recorded to Remarkable: Quiz

User Interaction & Debugging

  • Interaction & Debugging
  • Interaction and debugging 2020.pdf
  • Interactive Macros 2020.xlsm
  • Interactive Macros 2020.xlsm
  • Interaction and Debugging recording
  • Interactive Macros 2020 completed 20200820.xlsm
  • User Interaction & Debugging: Quiz

VBA Variables

  • VBA Variables
  • VBA Variables 2020.pdf
  • VBA Variables_2020.xlsm
  • VBA Variables recording
  • VBA Variables_2020_completed_20200825.xlsm
  • VBA Variables: Quiz

Bonus Content

  • Bonus 1 - Maximum Autofit column width
  • Bonus 1 - Auto Width Maximum video
  • Bonus 1 - Example file with Auto Width Limit macro
  • Bonus 2 - Constants
  • Bonus 2 - Constant video
  • Bonus 2 - Example file with Constant macro
  • Bonus 3 - Ranges
  • Bonus 3 - Example file with macro code
  • Bonus 3 - Ranges Video
  • Bonus 4 - Activating Sheet When File is Opened.pdf
  • Bonus 4 - OpenControl.xlsb
  • Bonus 4 - Open on Sheet video

Event Macros

  • Event Macros- automating your macros
  • Automating Macros 2020.pdf
  • Automation Using Events 2020.xlsm
  • Automating with Events recording
  • Automation Using Events 2020 completed.xlsm
  • Event Macros: Quiz

Function Macros

  • Function Macros
  • Function Macros 2020.pdf
  • Function Macros 2020.xlsm
  • Function Macros recording
  • Function Macros 2020 No Conditional Format completed.xlsm
  • Function Macros: Quiz

Macro Workshop 1

  • Macro Workshop 1
  • Macro Workshop 1 - 2020.pdf
  • Macro Workshop 1 - 2020.xlsm
  • Macros Workshop 1 recording
  • Macro Workshop 1 - 2020 - completed.xlsm
  • Macro Workshop 1: Quiz

Bonus - Macro Workshop 2

  • Macro Workshop 2
  • Bonus - Macro Workshop 2.pdf
  • Bonus - Macro Workshop 2.xlsm
  • Bonus - Macro Workshop 2 recording
  • Bonus - Macro Workshop 2 complete.xlsm

Creating an Excel Add-in

  • Creating an Excel Add-in
  • Creating an Excel Add-in
  • Report_Add-ins 2020.pdf
  • Report_Add_In_2020.xlsm
  • Report Add-in recording
  • Report_Add_In_2020_complete.xlam

More Bonus Content

  • Bonus 5 - PivotTable Listing Macro.pdf
  • Bonus 5 - PivotTable Listing Macro.xlsb
  • Bonus 5 - PivotTable Listing video
  • Bonus 6 - Stop Clearing the Clipboard.pdf
  • Bonus 6 - Stop_Clear_Clipboard.xlsb
  • Bonus 6 - StopClearClipboard video
  • Bonus 7 - Excel VBA to Remove Filters.pdf
  • Bonus 7 - RemoveFilter.xlsb
  • Bonus 7 - RemoverFilters video