Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Releative Cell vs Absolute cell
Is there a way to return the Releative Cell value vs the Absolute Cell
Value? I am using the following syntax: current_row = Selection.Address MsgBox(current_row) And the results a $A$1 (example) Thanks, mb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Releative Cell vs Absolute cell
mb,
current_row = Selection.Address(False, False) Help item below. HTH, Bernie MS Excel MVP Address property as it applies to the Range object. Returns the range reference in the language of the macro. Read-only String. expression.Address(RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo) expression Required. An expression that returns one of the above objects. RowAbsolute Optional Variant. True to return the row part of the reference as an absolute reference. The default value is True. ColumnAbsolute Optional Variant. True to return the column part of the reference as an absolute reference. The default value is True. ReferenceStyle Optional XlReferenceStyle. XlReferenceStyle can be one of these XlReferenceStyle constants. xlA1 default. Use xlA1 to return an A1-style reference. xlR1C1. Use xlR1C1 to return an R1C1-style reference. External Optional Variant. True to return an external reference. False to return a local reference. The default value is False. RelativeTo Optional Variant. If RowAbsolute and ColumnAbsolute are False, and ReferenceStyle is xlR1C1, you must include a starting point for the relative reference. This argument is a Range object that defines the starting point. Remarks If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns. "mb" wrote in message ... Is there a way to return the Releative Cell value vs the Absolute Cell Value? I am using the following syntax: current_row = Selection.Address MsgBox(current_row) And the results a $A$1 (example) Thanks, mb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming | |||
How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming |