R1C1 settings auto changing

  • Thread starter Thread starter essential
  • Start date Start date
E

essential

Excel Spreadsheet headers/columns A,B,C... are changing after a formula is
performed to numbers 1,2,3... This only happens on one spreadsheet not
others. How do I stop it from automatically changing?
 
Hi,

It happens if you open a workbook that has the R1C1 settings and I don't
believe you can stop it except by forcing the change back with a macro. in
the workbook open event module

Application.ReferenceStyle = xlA1

Mike
 
Hi,

I don't know what did you do?

You should have done this:-

Alt+F11 to open VB editor. Double click 'This workbook' and paste this in on
the right

Private Sub Workbook_Open()
Application.ReferenceStyle = xlA1
End Sub

Mike
 
This Macro hasn't solved the issue unfortunately.

Letters are still changing automatically.

Any other suggestions perhaps?
 
Originally I hadn't added the macro correctly. Since trying this Macro it has
not been successful. Are there any other suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

R1C1 switching automatically. 2
R1C1 problems - Can't change 15
Column headings 2
Having Blank Cells, etc. ? 1
Column Header is not in Letter 1
How do I change the column ID in Excel from number to text? 5
How can I change column titles back to numbers? 4
Change the properties of the worksheet row or column header bars 6

Back
Top