ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,227
- Office Version
- 2007
- Platform
- Windows
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
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