Thread: Invalid name?!?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Invalid name?!?

"Gord Dibben" wrote:
When using R1C1 reference style Excel won't accept
C or R as the prefix if followed by a number.


I see your point. And arguably Excel might also disallow it even when
__not__ using R1C1 reference style, as I did, since we might switch to R1C1
reference style at any time.

However, I don't believe that explains why "B0130" evokes the same error,
whereas "B01_03" is acceptable.

Any theory about the latter?