Forum Discussion
Andrea Ewers
Apr 30, 2018Copper Contributor
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 somew...
Haytham Amairah
Apr 30, 2018Silver Contributor
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