See at first how I record a Macro using the absolute reference. Select the cell A1. Go to the Developer tab and click on the Record Macro option in the Code ribbon. Record Macro dialog box appears. I put a name for the Macro (“Macro_Absolute”). And click OK button. Now I select cell range C3: C8 and fill it with Green background color.
You are awesome at Excel, but the world of VBA macros is intimidating. The macro recorder might work today, but the code fails tomorrow. This book will start at the macro recorder and show you the 4 settings that will let you record successful macros. You will then progress to understanding the recorded code and adding useful features such as loops, variables. Includes advanced topics such as custom user forms, creating pivot tables and more.
![Record A Macro Using Relative References In Excel 2016 For Mac Record A Macro Using Relative References In Excel 2016 For Mac](http://www.globaliconnect.com/excel/images/ExcelVBA/RecordMacro/recordmacro_2a.gif)
![Record a macro using relative references in excel 2016 for mac pro Record a macro using relative references in excel 2016 for mac pro](/uploads/1/2/5/5/125511725/122324414.jpg)
All code in the book is available for download. Includes the Content Update Program from QUE.