Reference>How to reference Cells and Ranges>Referring to Ranges Relative to Other Ranges

A common way to work with a range relative to another range is to use the Offset property.

Example

In the following example, the contents of the range that's two row down and three columns over from the selected range on the active worksheet are formatted as double-underlined.

WorkBook.ActiveSheet.Selection.Offset[2, 3].Font.Underline := xlDouble;

The following example makes the copy of range B5:G7 under it.

With WorkBook.Sheets[1].Range['B5','G7'] do begin
   Offset[Rows.Count, 0].Insert(xlShiftDown);
   Copy(Offset[Rows.Count, 0], xlPasteAll);
end;

NativeExcel suite v1.x

Referring to Ranges Relative to Other Ranges

Example