Export (0) Print
Expand All
Expand Minimize

Range.AddressLocal Property 

Returns the range reference for the specified range in the language of the user.

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

'Usage
Dim range1 As Range

Dim key As Object
Dim returnValue As String
returnValue = range1.AddressLocal(key)

'Declaration
ReadOnly Property AddressLocal( _
	<InAttribute()> Optional ByVal RowAbsolute As Object, _
	<InAttribute()> Optional ByVal ColumnAbsolute As Object, _
	<InAttribute()> Optional ByVal ReferenceStyle As XlReferenceStyle, _
	<InAttribute()> Optional ByVal External As Object, _
	<InAttribute()> Optional ByVal RelativeTo As Object _
) As String
public System.String get_Item(
	/*in*/System.Object RowAbsolute, 
	/*in*/System.Object ColumnAbsolute, 
	/*in*/XlReferenceStyle ReferenceStyle, 
	/*in*/System.Object External, 
	/*in*/System.Object RelativeTo
);
In JScript, you can use Indexed Properties defined by a class, but you cannot define your own.

Parameters

RowAbsolute

Optional Object. True to return the row part of the reference as an absolute reference. The default value is True.

ColumnAbsolute

Optional Object. True to return the column part of the reference as an absolute reference. The default value is True.

ReferenceStyle

Optional XlReferenceStyle.

External

Optional Object. True to return an external reference. False to return a local reference. The default value is False.

If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and all columns, respectively.


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

Community Additions

ADD
Show:
© 2014 Microsoft