Pair.RangeAddr Property

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference > Pair Object > Properties >

Pair.RangeAddr Property

Previous pageReturn to chapter overviewNext page

Returns or sets an optional range address for the specified member of the pair. Read only String value.

 

Syntax

expression.RangeAddr(id)

expression. A variable representing a Pair object.

 

Parameters

Name

Type

Description

id

sideID

Selects source or target worksheet.

 

 

Example

This example sets the range address.

 

With .Pairs

   .Add "db1", "db1"

   .Item(1).RangeAddr(sideID_src) = "A1:H50"

   .Item(1).RangeAddr(sideID_tgt) = "A1:H50"

End With