Range

A “Range” is a set of cells that you ask your macro to do something to (like copy for example). The cells A1:A5 in your Excel spreadsheet is an example of a range of cells. You’ll often find yourself working with ranges of cells when you’re creating macros. See our definition for “Select” because you need to know how to select a range of cells.

Recorder

R is for “Recorder”. A very squeaky instrument that quickly drives you insane when your kids start learning it at school and are told to take it home and practise. A modern form of torture that teachers are happy to inflict on their pupil’s parents. See also under M for “Macro recorder“.

Relative references

R also stands for “Relative references”. If you click the “Use relative references” button and record a macro, later when you play back your macro it will start working from whatever Excel cell your cursor happens to be in at the moment it runs. If you don’t click the use relative references button each time your macro runs it will do its work on the same particular cell you clicked at the time you created it. See under S for “Select” and also see “Use relative references“.

Run

R also stands for “Run”. All we’re talking about here is running or starting/ playing your “Macro” so that it repeats a certain sequence of steps in Excel. We’ve shown you how to play a macro manually and also run a macro automatically – so you know how to play a macro back super fast.

Macros coverage from the financial modelling course

You’re looking at the macros glossary from our course material covering the use of macros in Excel financial modelling.

...join the conversation...

Your email address will not be published. Required fields are marked *