get cell.address question
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 |
get cell.address question
"augustus" skrev i melding ... 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 |
get cell.address question
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 "augustus" skrev i melding ... 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 |
get cell.address question
Augustus
Try rng.Address(RowAbsolute:=False, ColumnAbsolute:=False) where rng is your range object. -- Charles www.officezealot.com "augustus" wrote in message ... 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 |
get cell.address question
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 "augustus" wrote: 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 |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com