Offset Property (Range Object)

See Also         Example         Applies To

Returns a Range object that represents a range that’s offset from the specified range. Read-only.

Syntax

expression.Offset(RowOffset, ColumnOffset)

expression   Required. An expression that returns a Range object.

RowOffset   Optional Variant. The 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.

ColumnOffset   Optional Variant. The 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.