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

  • 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 https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10323087-bring-back-relative-references-in-macro-recording in the Excel's suggestions box asking for this option to bring it back, you can vote for it.

     

    Regards

Resources