Issues with the columns heading setting 1

[cogivina]

Hi,

After I run the application using VBA in excel, all the columns were converted to numbers instead of alphabet letters. I don't know what code in the marco to change the setting. Even when I close out the Excel and come back in, the spread sheet still shows in the format R[1]C[1] instead of A1. How do I reset the column setting back to normal?

Thanks.

 

[PHV]

Application.ReferenceStyle = xlA1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886