Macro running with absolute reference despite being created with relative

Question

For years I have created a simple macro for "Insert Row (s) and copy column formulae down. I always use relative reference button and have had no problems. However, recently, no mater how I create the macro, it only runs with absolute reference. Any similar experiences?

Answer 1

If your macro is running with absolute references despite being created with the relative reference option, it could be due to a few reasons:

1. Macro Recording Settings: Ensure that the relative reference option is activated before you start recording the macro. If it was not activated, the macro will default to absolute references.
2. Trust Center Settings: Sometimes, security settings in the Trust Center can affect how macros run. Check your macro settings to ensure that they allow for the execution of macros as intended.
3. Excel Updates or Changes: If there have been recent updates to Excel, they might have affected how macros behave. It's worth checking if there are any known issues with the current version of Excel you are using.
4. Manual Edits: If you manually edit the macro after recording, ensure that you do not inadvertently change the references from relative to absolute.

If the problem persists, consider re-recording the macro while ensuring that the relative reference option is selected.

---

References:

• Refer to Cells Relative to Other Cells
• Sample macro to insert/delete rows or columns on multiple sheets in Excel