Turn off R1C1 reference style via VBA
 

I would like a macro for the auto open event of my sheet to turn off R1C1
reference style (Tools-Options-General Tab). How would I do this?

Mike

Turn off R1C1 reference style via VBA
 

Ah....nevermind. I figured it out.

Application.ReferenceStyle=xlA1

"Mike Milligan" wrote in message
...
I would like a macro for the auto open event of my sheet to turn off R1C1
reference style (Tools-Options-General Tab). How would I do this?

Mike