Application.RecordRelative Property (Excel)
True if macros are recorded using relative references; False if recording is absolute. Read-only Boolean.
Syntax
expression .RecordRelative
expression A variable that represents an Application object.
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