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.

Macro Essentials Course

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
  • Macros 2 Recorded to Remarkable 2020.pdf
  • Macros 2 Recorded To Remarkable 2020.xlsm
  • Macros 2 Recorded To Remarkable 2020 completed.xlsm
  • Macros 2 Recorded to Remarkable recording
  • Recorded to Remarkable: Quiz

User Interaction & Debugging

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

VBA Variables

  • VBA Variables
  • Macros 8 Variables 2020.pdf
  • Macros_8_Variables_2020.xlsm
  • Macros 8 VBA Variables Video
  • Macros_8_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 - OpenControl.xlsb
  • Bonus 4 - Activating Sheet When File is Opened.pdf
  • Bonus 4 - Open on Sheet video