{"id":14722,"date":"2018-04-09T15:51:18","date_gmt":"2018-04-09T15:51:18","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14722"},"modified":"2022-08-17T19:17:44","modified_gmt":"2022-08-17T19:17:44","slug":"recording-macro-relative-references-and-absolute-method","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2018\/04\/recording-macro-relative-references-and-absolute-method\/","title":{"rendered":"Recording Macro – Relative References and Absolute Method"},"content":{"rendered":"
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”]Dear Friends,<\/p>\n
This article is intended for Excel VBA beginners. Here in this article, I am going to explain to you the use of the Use Relative Reference<\/em> option in Excel VBA while recording your macro. <\/p>\n My focus in this article would be on explaining you these two different methods which you can use while recording – Under the Developer tab in your Excel workbook, you can see there is a toggle option available below the record macro button as shown in the below picture.
\n1. <\/em>Use Relative Reference Method
\n2. <\/em>Absolute Method\n<\/p>\n
\nWhat is Excel Macro ?<\/a>
\nHow to Record \/ Run Excel Macro ?<\/a>\n<\/div>\nWhat is Relative Reference Option in Macro Recording<\/h1>\n
\nTo know how to enable Developer tab in your Excel Workbook, click here<\/a><\/p>\n