Range.Address: RelativeTo parameter

[douglasH]

Excel 2007:

I was playing around with Range.Address. For what purposes would the parameter RelativeTo be used?

The following code returns "R[-1]C[-1]":

Code: Select all

Dim r As Range

Set r = Range("A1")

MsgBox r.Address(RowAbsolute:=False, ColumnAbsolute:=False, _
      ReferenceStyle:=xlR1C1, RelativeTo:=Range("B2"))

Thanks.

[Rudi]

It provides the offset values for row and column to match the original reference.
As for it's purpose; I've never had the need for using it, so I'm not sure myself...

[douglasH]

Thanks, Rudi... I guess it's just good to know RelativeTo is there if I ever need it.