When I generate a macro to change the name of the columns of an Excel sheet from A, B, C, etc to 1, 2, 3, etc,the code that appears is:
With Application
.ReferenceStyle=x1R1C1
.UserName="zzzz"
.StandardFont'"Arial"
.StandardFontSize="10"
.DefaultFilePath="C:\Documents and Settings\zzzz\MyDocuments"
.EnableSound=False
.RollZoom=False
End With

and it works O.K.

When I intend to use similar codes in a VB program I get error ( as if x1R1C1 is a variable not defined). I suspect that I need the values of the constants x1R1C1 as well as the values for x1L1C1 and x1A1.

Can anyone give me the values of these constants...or where can I get them?
Thanks!!