Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Reserved words

Mystery solved Thanks again to you both

Mike

"Stefi" wrote:

David is right, C and R stands for column and row respectively. The reason
why my Excel accepted these letters is that I use a national language version
in which O and S are the equivalents of C and R. Using O or S I got the error
message!
And also Mike is right when he misses documentation of this constraint!

Stefi



€˛Mike H€¯ ezt Ć*rta:

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is a 'reserved name' and how do I get rid of it? crusoe Excel Discussion (Misc queries) 3 February 16th 07 03:54 AM
Renaming Worksheet: Error message: "Reserved Name" thank you! Excel Discussion (Misc queries) 1 September 29th 05 05:01 PM
File is "Reserved" Gordon New Users to Excel 1 September 14th 05 07:48 PM
Reserved by - Protected Firyali Excel Worksheet Functions 0 July 5th 05 08:10 PM
reserved sheet name rose Excel Worksheet Functions 6 March 18th 05 01:29 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"