View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

No but you can create a macro to do this. First, paste this code into the
VBA editor (Alt+F11):

Sub ChangeReferenceStyle()
With Application
If (.ReferenceStyle = xlA1) Then
.ReferenceStyle = xlR1C1
End
Else:
.ReferenceStyle = xlA1
End If
End With
End Sub

Then, Tools-Macro-"Macros..." Select the macro, hit "Options" and enter
the shortcut key you would like to toggle this.


--
Regards,
Dave


"kemasch" wrote:


Does a keyboard shortcut exist to toggle the R1C1 function?


--
kemasch
------------------------------------------------------------------------
kemasch's Profile: http://www.excelforum.com/member.php...o&userid=27785
View this thread: http://www.excelforum.com/showthread...hreadid=472967