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

\nExcel VBA Programming The Complete Guide - The Range.Offset Property\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 Range.Offset property shifts the currently selected range to a new one. It accepts two arguments -- the number of rows and the number of columns to move. Positive arguments represent downward movements for rows and rightward...\nThe Range.Offset property shifts the currently selected range to a new one. It accepts two arguments -- the number of rows and the number of columns to move. Positive arguments represent downward movements for rows and rightward movements for columns; negative arguments represent upward movements for rows and leftward movements for columns.

This clip is from the chapter \"Range References\" of the series \"Excel VBA Programming–The Complete Guide\".In this section, work on FormulaRICI properties and methods.\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
5:05
\n
\n
\n
\n
\n
Grade
Higher Ed
\n
\n
\n
\n
\n
Subjects
STEM
3 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
\n
\n\n\n
\n
\n
\n
\n

Additional Tags

\n
\n
excel vba programming, excel, visual basic, excel object model, negative integer, cell a1, cell c5, cell c3, offset property, row offset, offset, select, argument, upwards, column, starting, left, move, lesson, start, rows, columns, worksheet, window, positive, 0 columns, started, moved, leftwards, provide, number, means
\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 - The Range.Offset Property\" href=\"/subscription/new\">\"Excel\n\n
\n
\n
\n\n\n\n"}