Range.Offset (Excel)

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

Offset (RowOffset, ColumnOffset)


Worksheets("Sheet1").Activate 
ActiveCell.Offset(rowOffset:=3, columnOffset:=3).Activate

Arguments

Optional arguments

The following arguments are optional

RowOffset (Long) - 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 (Long) - 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.