The Best Tips for Recording Macros in Excel

Add to Favorites
Author: | Edits: don

This is for the beginner who wants to start learning about how to record macros in Excel and then edit them to work better.

This tutorial, combined with the next one, will get you on your way to building more robust and useful macros in Excel, especially when starting out using the Macro Recorder.

The topics covered here include:

  • the most common issues that you will run into when recording a macro
  • how to edit a recorded macro
  • how to make recorded macros relative so they work on the currently selected cells
  • how to record a macro using "relative cell references"
  • and also a great tip on how to find out more about the code that is in your recorded macro - this tip will provide you a great tool for further customizing your macro with minimal effort.

Hope you enjoy the tutorial!


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Get Data from the Worksheet into a Macro in Excel
Tutorial: Here, you'll learn how to get information from the Excel worksheet into a macro so you can...
5 Simple Tips for Making BETTER Macros in Excel!
Tutorial: 5 ways to make better Macros in Excel - fewer errors, smoother coding, less fuss! These 5...
3 Slicer Tricks for Pivot Tables in Excel
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...
What is a Macro in Excel?
Tutorial: This is the first step to learning about Macros for Excel and how to use them.  What is a...
Confirm User Input using VBA and Macros in Excel
Tutorial: View the Full VBA/Macro Course How to have a user confirm their input using vba - this fe...
Run a Macro from Another Macro in Excel
Tutorial: I will show you how to run a macro from another macro in Excel.  This means that you can...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course