Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
True if macros are recorded using relative references; False if recording is absolute. Read-only Boolean.
Example
This example displays the address of the active cell on Sheet1 in A1 style if RecordRelative is False; otherwise, it displays the address in R1C1 style.
Worksheets("Sheet1").Activate
If Application.RecordRelative = False Then
MsgBox ActiveCell.Address(ReferenceStyle:=xlA1)
Else
MsgBox ActiveCell.Address(ReferenceStyle:=xlR1C1)
End If
Applies to | Application Object