Help with Macro

[Simon S]

Hi,

I am new to macros and I need some help

I regularly have to change the reference style from x1A1 to x1R1C1 and back
again. So I made the following macro using Ctrl+Shift+T as the keyboard
short cut

Application.ReferenceStyle = xlR1C1
End Sub

Is there a way I can get it to toggle, i.e. each time I press Ctrl+Shift+T
it will change to other reference style, if I am in x1A1 it will change to
x1R1C1 and vice versa

Thanks

 

[Rick Rothstein]

This single statement will toggle between the two settings...

Application.ReferenceStyle = (xlR1C1 + xlA1) - Application.ReferenceStyle

 

[Simon S]

Rick, Great help, thanks

This single statement will toggle between the two settings...

Application.ReferenceStyle = (xlR1C1 + xlA1) - Application.ReferenceStyle

 

[Harald Staff]

That's a clever one