Make your VBA macros work anywhere: Enable Relative References

Do you know that while recording macros in excel you can use the relative reference based recording so that you can use your macro anywhere and the references would be adjusted automatically?

Yes!

I have learned this yesterday and I thought it is pretty cool.

Here is how you can make your macro VBA code references relative:

When you select “record new macro” from menu > tools > macros, excel shows a very little macro recording toolbar with a start button and another button. That another button is the one we use to toggle between relative and absolute references in macro code.

See this:

And the code generated by relative and absolute references is shown here:

Posts & Navigation Have an Excel Question? « Excel Links of the Week – Do you want to run 10k with me edition What would you like to ask Charley Kyd of Exceluser.com in an interview? » Go Back to Home Page Tags: help, howto, Learn Excel, macros, OFFSET(), references, spreadsheets, VBA

Comments

RSS feed for comments on this post. TrackBack URI

Leave a comment

If you have a question, please ask in the forums