The Complete Macro Series
- Buy now
- Learn 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

Creating an Excel Add-in

6 Lessons