Columns Letters to Number keep changing

[ipbr21054]

Hi,

Sometimes after i press a command button i see a RTE
Clicking debug shows me the line of code that is the cause.

What ive noticed is the code shows example Range("P7").Select in yellow.
The issue is because for some unknown reason the columns are now shown as 1,2,3 etc as opposed to A,B,C

Changing the R1C1 option in the settings does fix this BUT why does it keep changing from numbers to letters on its own every now & then ?

Thanks

 

[ipbr21054]

FYI, the fact that your Excel GUI is showing column numbers would not prevent a reference like Range("P7") from working.

This was shown in yellow.
I looked at the page to see 1,2,3,4 etc as opposed A,B,C,D,E

I changed from 1,2,3 to A,B,C & run the code.
It worked fine.

Changed it back to 1,2,3 & RTE shown with this same line in yellow

 

[RoryA]

I suspect it was more to do with which sheet you activated when switching back and forth.