get cell.address question

[Guest]

Hi,

Is there way to reture the address of a cell without an absolute reference?

Ie, I want address in A4:B7 format, and not in $A$4:$B%7 format.

I'm using Office2003

 

[Harald Staff]

Hi,

Is there way to reture the address of a cell without an absolute reference?

Ie, I want address in A4:B7 format, and not in $A$4:$B%7 format.

I'm using Office2003

 

[Harald Staff]

Sub test()
MsgBox Selection.Address
MsgBox Selection.Address(True, False)
MsgBox Selection.Address(False, True)
MsgBox Selection.Address(False, False)
MsgBox Selection.Address(True, True, xlR1C1)
MsgBox Selection.Address(False, False, xlR1C1)
End Sub

HTH. Best wishes Harald

 

[Charles Maxson]

Augustus

Try
rng.Address(RowAbsolute:=False, ColumnAbsolute:=False)

where rng is your range object.

 

[Guest]

The Address method has rowAbsolute and columnAbsolute arguments. For
example, to assign the activecell address to the variable c you would use:

c = Activecell.Address(rowAbsolute:=False, columnAbsolute:=False)

Stan Shoemaker
Palo Alto, CA