jakelosh/vbaToggleR1C1

Created June 24, 2013 16:31

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jakelosh/5851415.js"></script>
Save jakelosh/5851415 to your computer and use it in GitHub Desktop.

Download ZIP

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

Raw

vbaToggleR1C1

	Public Sub ToggleR1C1()
	If Application.ReferenceStyle = xlR1C1 Then
	Application.ReferenceStyle = xlA1
	Else
	Application.ReferenceStyle = xlR1C1
	End If
	End Sub

timbledum commented Mar 26, 2019

Thanks for this! Works a treat!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment