Offset Method

         Example         Applies To

Returns a Range object that represents a range that is offset from the specified range.

Syntax

expression.Offset(NumberOfRows, NumberOfColumns)

expression   An expression that returns a Range object.

NumberOfRows   Optional Long. The number of rows (positive, negative, or zero (0)) by which the range is to be offset. The default value is zero.

NumberOfColumns   Optional Long. The number of columns (positive, negative, or zero) by which the range is to be offset. The default value is zero.