Forum Discussion

Andrea Ewers's avatar
Andrea Ewers
Copper Contributor
Apr 30, 2018

Recording macros with relative referencing in Excel 2016

How do I turn on relative referencing when recording a macro in Excel for Mac 2016? There is a button in the Windows version but I cannot find this function in the Mac version. Surely it exists somewhere, given macros are pretty limited (useless, even) if they can only record absolute referencing... please help!

Macros & VBA
Need Help

1 Reply

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 30, 2018

    Hi Andrea,

     

    This option is no longer available in Excel 2016 for Mac!

    By the way, there is an idea in the Excel's suggestions box asking for this option to bring it back, you can vote for it.

     

    Regards

Resources