{"page":"\n\n
\n
\n
\n
\n
\n\nVideo\n
\n

\nExcel VBA Programming The Complete Guide - Absolute vs. Relative References I\n

\n
\n
\nGet Free Access for 10 Days!\n
\n
\n
\n
\n
\n
×
\n\n\n
\n\nPublisher:\n\nCurated Video\n\n\n
\n
\nThe Macro Recorder can record with absolute or relative references. Absolute references (the default recording option) target specific cells (i.e. B1) -- the recorder is more concerned with the destination. Relative references record...\nThe Macro Recorder can record with absolute or relative references. Absolute references (the default recording option) target specific cells (i.e. B1) -- the recorder is more concerned with the destination. Relative references record changes relative to a cell -- the recorder is more concerned with the steps of travel from a starting position. In this lesson, we record one macro with each type of reference and compare the generated code in the Visual Basic Editor.

This clip is from the chapter \"Getting Started\" of the series \"Excel VBA Programming–The Complete Guide\".In this lesson, we introduce Visual Basic for Applications (VBA), a powerful language for automating operations in Microsoft Office applications.\n
\n
\n\n
\n
\n
\n
\n

Resource Details

\n
\n
\n
\n
Curator Rating
\n
\n
\n
\n
\n
\n
Educator Rating
Not yet Rated
\n
\n
\n
\n
\n
Media Length
\n
8:13
\n
\n
\n
\n
\n
Grade
Higher Ed
\n
\n
\n
\n
\n
Subjects
Science
8 more...
\n
\n
\n
\n
\n
Media Type
Instructional Videos
\n
\n
\n
\n
\n
Source:
\n
\nPackt - Business & Other\n\n
\n
\n
\n
\n
\n
Date
\n
2022
\n
\n
\n
\n
\n\n
Language
English
\n
\n
\n
\n
\n
Audiences
For Teacher Use
2 more...
\n
\n
\n
\n
\n
Usage Permissions
Fine Print: Educational Use
\n
\n
\n
\n
\n
\n

Additional Materials

\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Transcript\n
\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Preview\n
\n
\n
\n

Concepts

\n
\n
arrays, range, navigation
\n
\n\n\n
\n
\n
\n
\n

Additional Tags

\n
\n
excel vba programming, excel, visual basic, excel object model, absolute reference, specific location, arrow key, final destination, cell b1, cell a1, active cell, cell d6, relative references, macro recorder, starting position, excel workbook, relative macro, execute move, absolute, cell, relative, macro, move, starting, execute, default, kind, control, line, code, back
\n
\n\n\n
\n
\n
\n
\n

Classroom Considerations

\n
Best For: Explaining a topic
Video is ad-free
\n
\n
\n

Educator Ratings

\n
\n
\n
\n
\n
\n\nShow resource details\n
\n
\n\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" aria-label=\"Play video: Excel VBA Programming The Complete Guide - Absolute vs. Relative References I\" href=\"/subscription/new\">\"Excel\n\n
\n
\n
\n\n\n\n"}