ToggleR1C1 allows you to toggle back and forth between R1C1 notation in Excel and A1 notation. I like to assign this macro to the keyboard shortcut CTRL + SHIFT + R

vbaToggleR1C1

Public Sub ToggleR1C1()
    If Application.ReferenceStyle = xlR1C1 Then
        Application.ReferenceStyle = xlA1
    Else
        Application.ReferenceStyle = xlR1C1
    End If
End Sub

Thanks for this! Works a treat!