How would you use a relative cell reference in a macro?
A)Click Use Relative References before you perform the commands.
B)Press F4 when selecting the range.
C)You must edit the macro in the VBA editor to change the reference type.
D)Hold the Shift key down while recording the macro.

Question

Quizplus · Accepted Answer

You need to click on the "Use Relative References" button in the Developer tab before recording the macro. This will allow the macro to use relative cell references instead of fixed cell references.

How Would You Use a Relative Cell Reference in a Macro