Activate R1C1 Reference Style Activate A1 Reference Style

Activate R1C1 Reference Style

This macro code will help you to activate R1C1 reference style without using Excel options.

Sub ActivateR1C1()

If Application.ReferenceStyle = xlA1 Then

Application.ReferenceStyle = xlR1C1

Else

Application.ReferenceStyle = xlR1C1

End If

End Sub

Activate A1 Reference Style

This macro code will help you to activate A1 reference style without using excel options.

Sub ActivateA1()

If Application.ReferenceStyle = xlR1C1 Then

Application.ReferenceStyle = xlA1

Else

Application.ReferenceStyle = xlA1

End If

End Sub