0 out of 4 rated this helpful - Rate this topic

Range.Range Property

Office 2003

Office 2010

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Usage

'Usage
Dim range1 As Range

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

Syntax

C++

Range this[
	[In] object Cell1, 
	[In, Optional] object Cell2
] {get;}

public Range get_Item(
	/*in*/System.Object Cell1, 
	/*in*/System.Object Cell2
);

JScript

In JScript, you can use Indexed Properties defined by a class, but you cannot define your own.

Parameters

Cell1: 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.

Remarks

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.

Thread Safety

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

Platforms

Development Platforms

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

Target Platforms

Reference

Range Interface
Microsoft.Office.Interop.Excel Namespace

Other Resources

Range Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD