Comparing Absolute and Relative Macro Recording

Comparing Absolute and Relative Macro Recording

Comparing Absolute and Relative Macro Recording

 

  (Getting Started with Excel Macros)

Now that you've read about the basics of the Macro Recorder interface, it's time to go deeper and begin recording macros. The first thing you need to understand before you begin is that Excel has two modes for recording — absolute reference and relative reference.

Recording macros with absolute references

Excel's default recording mode is in absolute reference. As you may know, the term absolute reference is often used in the context of cell references found in formulas. When a cell reference in a formula is an absolute reference, it does not automatically adjust when the formula is pasted to a new location.

The best way to understand how this concept applies to macros is to try it out. Open the Chapter 1 Sample File.xlsx file and record a macro that counts the rows in the Branch list worksheet. (See Figure 2.)

Becoming Familiar with Macro Recording Basics

  (Getting Started with Excel Macros)

 
Getting Started with Excel Macros

This Part is a primer on Excel macros, covering everything you need to know about Excel macros and VBA to get started with the 101 macros throughout the rest of this book.

You need not be a power user to create and use simple VBA macros. Even casual users can simply turn on Excel's macro recorder.

Recording a macro is like programming a phone number into your cell phone. You first manually dial and save a number. Then when you want, you can redial those numbers with the touch of a button. Just as with numbers on a cell phone, you can record your actions in Excel while you perform them. While you record, Excel gets busy in the background, translating your keystrokes and mouse clicks to written VBA code. After you've recorded a macro, you can play back those actions anytime you wish.

This Part serves as an introduction to Excel Macros and VBA in general. Here, we give you a concise summary of how VBA works with Excel, giving you the basic foundation you need to work with the 101 macros listed in this book.

Becoming Familiar with Macro Recording Basics

To start recording your first macro, you need to first find the Macro Recorder, which is on the Developer tab. Unfortunately, Excel comes out of the box with the Developer tab hidden — you may not see it on your version of Excel at first. If you plan to work with VBA macros, you'll want to make sure that the Developer tab is visible. To display this tab

1. Choose Office→Excel Options.
2. In the Excel Options dialog box, select Customize Ribbon.
3. In the list box on the right, place a check mark next to Developer.
4. Click OK to return to Excel.

Now that you have the Developer tab showing in the Excel Ribbon, you can start up the Macro Recorder by selecting Record Macro from the Developer tab. This activates the Record Macro dialog box, as shown in Figure 1.

 

 Figure 1-1: The Record Macro dialog box

Here are the four parts of the Record Macro dialog box:

101 Ready to use Excel Macros

      Welcome to My blog reader ,,  I'd like to share with you about the great excel macro how it works. Now macro is very very simple at the same time  important to learn in today industry field, because it will reduce and saving our time to grow our work fast.  Please see below contents of 101 Ready-To-Use Excel Macros  book .