Excel.Application.RecordRelative.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.RecordRelative property (Excel)	vbaxl10.chm133196	vbaxl10.chm133196	Excel.Application.RecordRelative	64e634e4-30e2-0794-1120-0960e32fe821	04/05/2019	medium

Application.RecordRelative property (Excel)

True if macros are recorded by 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

[!includeSupport and feedback]