Sub ActivateR1C1()
If Application.ReferenceStyle = xlA1
Then
Application.ReferenceStyle = xlR1C1
Else
Application.ReferenceStyle = xlR1C1
End If
End Sub
Sub ActivateR1C1()
If Application.ReferenceStyle = xlA1
Then
Application.ReferenceStyle = xlR1C1
Else
Application.ReferenceStyle = xlR1C1
End If
End Sub
Sub ActivateR1C1() If Application.ReferenceStyle = xlA1 Then Application.ReferenceStyle = xlR1C1 Else Application.ReferenceStyle = xlR1C1 End If End Sub
Ce code de macro vous aidera à activer le style de référence R1C1 sans utiliser les options Excel.