Toggles cell referencing style:

PHOTO EMBED

Wed Sep 08 2021 06:05:38 GMT+0000 (UTC)

Saved by @Darkleech #vba

Sub ToggleR1C1() 'Toggles cell referencing style:
'http://blog.contextures.com/archives/2009/12/04/excel-vba-switch-column-headings-to-numbers/
   If Application.ReferenceStyle = xlA1 Then
        Application.ReferenceStyle = xlR1C1
    Else
        Application.ReferenceStyle = xlA1
    End If
End Sub
content_copyCOPY