Export (0) Print
Expand All
Expand Minimize

Range.Offset Property

Office 2007
Returns a Range object that represents a range that’s offset from the specified range.

Syntax

expression.Offset(RowOffset, ColumnOffset)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
RowOffsetOptionalVariantThe number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.
ColumnOffsetOptionalVariantThe number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.

Example

This example activates the cell three columns to the right of and three rows down from the active cell on Sheet1.

Visual Basic for Applications
Worksheets("Sheet1").Activate
ActiveCell.Offset(rowOffset:=3, columnOffset:=3).Activate

This example assumes that Sheet1 contains a table that has a header row. The example selects the table, without selecting the header row. The active cell must be somewhere in the table before the example is run.

Visual Basic for Applications
Set tbl = ActiveCell.CurrentRegion
tbl.Offset(1, 0).Resize(tbl.Rows.Count - 1, _
    tbl.Columns.Count).Select



Community Additions

ADD
Show:
© 2014 Microsoft