Flora Edwards
asked on
where is the button of Relative Reference in Developer Tab Excel In MAC
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you both.
Glad to help
ASKER
sometimes i automate some of data cleanups using macro recorder and then adding a loop into it. if i do not have the option of relative reference, then my macros would not be recorded correctly in MAc excel.
is there any way to still be able to record macro in excel 2016 for MAC using relative reference?