Edit Macros - Excel VBA , Modify Recorded Macros - Part 10

Learn how to edit recorded macros in Excel and produce dynamic macros that work in different situations. In this tutorial we will first modify our macros to find and use the last row in our data, then introduce some message boxes for better user experience as well as add some basic error handling.

This tutorial is Part 10 from Excel VBA Programming - Beyond Recording Macros series.

#excel #macros #vba

[Lesiegar]

how do you get to the VBA if it’s. password protected?

[MrBekimpilo]

I have a problem in that when i use the lr variable the way you did I get "Run time error 91"