Expand Minimize

Application.RecordRelative Property (Excel)

True if macros are recorded using relative references; False if recording is absolute. Read-only Boolean.

expression .RecordRelative

expression A variable that represents an Application object.

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

Community Additions

ADD
Show:
© 2014 Microsoft