Solved: R1C1 AND Letters - is there a way to see both

[betty]

Hello All. I'm in Excel 2007, and find my self going back and forth between R1C1 display and letters for Columns constantly. Wondered if anyone knew a way to display both, or alternately a shortcut instead of going to the Office button, Excel options, Formulas etc. Am I crazy or would anyone else find this helpful? Thanks in advance.

Betty

[Bob Phillips]

Just write a simple macro



Sub ToggleReferenceStyle()

With Application

.ReferenceStyle = IIf(.ReferenceStyle = xlR1C1, xlA1, xlR1C1)
End With
End Sub


add a button to the QAT and assign it to that button

[betty]

Thanks for making my Friday. Worked like a charm. You rock.

Betty.