David,

That seems sensible and I do get the same error when trying to use R but it
doesn't explain why Stefi doesn't get the error with C.

I'm not sure how authorative this is but there is no mention of this
seemingly undocumented feature here.

http://ezinearticles.com/?Rules-For-...xcel&id=218607

Thanks for the Info'

Mike

"David Biddulph" wrote:

If my memory serves me right, C and R can't be used by they are used as
designations for column and row respectively. (Other letters are accepted.)
You can use R or C if preceded, or followed, by an underscore.
--
David Biddulph

"Mike H" wrote in message
...
Hi,

Why are C or c invalid names for named ranges on a worksheet?

Mike