We’re going to finish off discussion on recording macros by teaching you to clean them up and make them look more professional.

Last week, we talked about recording macros to let you repeat and automate sets of commands. Today, we’re going to look at how you can adapt those recorded macros, without relying on specific cell references.

Last week, we talked about recording macros to let you repeat and automate sets of commands. Today, we’re going to look at the code behind those automated commands.

Every Friday, we intend to post a blog talking about VBA and highlight the benefits, the pitfalls, and cover a range of basic concepts that everyone who uses VBA should know.

If you’ve never used macros but want to understand how they work, this series is for you...