This documentation is archived and is not being maintained.

Range.Range Property 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim range1 As Range

Dim key As Object
Dim returnValue As Range
returnValue = range1.Range(key)

Range this[
	[In] object Cell1, 
	[In, Optional] object Cell2
] {get;}
public Range get_Item(
	/*in*/System.Object Cell1, 
	/*in*/System.Object Cell2
In JScript, you can use Indexed Properties defined by a class, but you cannot define your own.



Required Object. The name of the range. This must be an A1-style reference in the language of the macro. It can include the range operator (a colon), the intersection operator (a space), or the union operator (a comma). It can also include dollar signs, but they’re ignored. You can use a local defined name in any part of the range. If you use a name, the name is assumed to be in the language of the macro.

This property is relative to the Range object. For example, if the selection is cell C3, then Selection.Range("B1") returns cell D3 because it’s relative to the Range object returned by the Selection property. On the other hand, ActiveSheet.Range("B1") always returns cell B1.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms