Why is R2K_Incept an invalid name for a named range?

  • Thread starter Thread starter Jeremy Gollehon
  • Start date Start date
J

Jeremy Gollehon

Repeat subject:
Why is R2K_Incept an invalid name for a named range?

Thanks,
-Jeremy
 
maybe you have used this name already? Otherwise this sholuld be
accepted
...

I've tried it in XL8/97. It's not accepted. No name beginning with R or C
immediately followed by a decimal numeral is accepted. I'd guess this is legacy
'functionality' due to the limitations of the formula parser in the original
Excel when using R1C1 addressing.
 
Harlan said:
...
..

I've tried it in XL8/97. It's not accepted. No name beginning with R
or C immediately followed by a decimal numeral is accepted. I'd guess
this is legacy 'functionality' due to the limitations of the formula
parser in the original Excel when using R1C1 addressing.


Thanks Harlan,
At least that makes some sense, however frustrating it is.
I'm using XL2003, so it hasn't been dealt with yet. Would you consider this
a bug that should be reported (not that it will matter)?
 
...
...
I'm using XL2003, so it hasn't been dealt with yet. Would you consider this
a bug that should be reported (not that it will matter)?

I'm certain Microsoft considers this a feature, and they won't change it because
doing so would impair backwards compatibility.
 
Hi Harlan
interesting. In Excel 2003 (German version) this name is accepted
without any problems
 
Hi
o.k. MS also decides to localize this 'feature'- So for me a name
starting with 'Z' or 'S' is not allowed.

--
Regards
Frank Kabel
Frankfurt, Germany


Jeremy said:
Thanks Harlan,
At least that makes some sense, however frustrating it is.
I'm using XL2003, so it hasn't been dealt with yet. Would you
consider this a bug that should be reported (not that it will
matter)?
 
Back
Top