Excel 2010, Is there a way to toggle the "R1C1" check box in the Options/Formulas/screen? 1

[DougP]

I need to frequently switch back and forth to determine either the column Letter or the column number.

Is there a way to create a Quick Access Toolbar button to run some code or something to switch this?
this is in the "Options" menu
then "Formulas" tab
"Working with Formulas" section
then check the "R1C1 reference style" box or uncheck it.

DougP

 

[PHV]

Application.ReferenceStyle = xlR1C1
Application.ReferenceStyle = xlA1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DougP]

Sweet PHV

I added this to it, so my button toggles it back and forth.

Public Sub ToggleR1C1()
' ToggleR1C1 Macro  This macro toggles the R1C1 in the Options menu Formulas
'                   put in a Module in the Personal.xlsb
'                   then create a quick access tool bar button 
    If Application.ReferenceStyle = xlR1C1 Then
        Application.ReferenceStyle = xlA1
    Else
        Application.ReferenceStyle = xlR1C1
    End If
End Sub

DougP