Reasons for Relative Reference Not Working

In Excel, relative referencing occasionally fails to function. The “Use Relative References” function being disabled is one potential explanation for relative referencing not being functional.

Solution

To fix the issue, press the “Use Relative References” button from the Developer menu before carrying out any actions.

I covered Excel Macro Relative Reference in this post. Hopefully, it would benefit everyone. I advise you to read more articles on Excel if you want to understand more. I appreciate your time and look forward to hearing from you soon!

We have two options to refer a cell in Excel VBA Absolute references and Relative references.  Default Excel records macro in Absolute mode.

In this article, we learn about Relative references in Excel VBA.  We select a cell “A1”, turn on “Use Relative Reference” and record a macro to type some text in cells B2:B4.  

Since we turn on the “Relative reference” option.  Macro considers the number of rows and columns from active cells.  In our example, we select cell A1 and start type B2, which is to move one column and one row from A1 (Active cell).