Reference>IXLSWorksheet>Range

Returns a Range object that represents a cell or a range of cells.

Syntax

property Range[Cell1: string, Cell2: string]: IXLSRange;

Cell1	String. This must be an A1-style reference to the cell in the upper-left corner of the range.
Cell2	String. This must be an A1-style reference to the cell in the lower-right corner of the range.

This example sets the value of cell A1 on the first sheet to 3.14159.

Workbook.Sheets[1].Range['A1','A1'].Value := 3.14159;

This example sets the font style in cells A1:D10 on the first sheet to bold.

Workbook.Sheets[1].Range['A1', 'D10'].Font.Bold := True;