SomeUser59
jakelosh
/ vbaToggleR1C1
Created
June 24, 2013 16:31
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Public Sub ToggleR1C1() | |
| If Application.ReferenceStyle = xlR1C1 Then | |
| Application.ReferenceStyle = xlA1 | |
| Else | |
| Application.ReferenceStyle = xlR1C1 | |
| End If | |
| End Sub |