Results 1 to 8 of 8

Thread: Why can't I use named range 'R3PM' ?

  1. #1
    New Member
    Join Date
    Oct 2018
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Why can't I use named range 'R3PM' ?

    Hi experts!

    In our company we have a program called 'R3PM' and we want to use it as a named range. But we get the error: "The syntax of this name isn't correct." Why do we get this error? Is it because letter 'R' is reserved and after it comes a number (3)?

    Thanks for the answers!

    Roy

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,970
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    Welcome to the forum.

    Quote Originally Posted by Roy_Excel_Island_Apps View Post
    Is it because letter 'R' is reserved and after it comes a number (3)?
    Yes, that is exactly why.

  3. #3
    New Member
    Join Date
    Jan 2016
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    Hi Roy,

    You can't use the uppercase and lowercase characters "C", "c", "R" or "r" as a defined name, because they are all used as a shorthand for selecting a row or column for the currently selected cell when you enter them in a Name or GoTo textbox.

    Use an underscore (_) as first character. (_R3PM)

    Grtz


  4. #4
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,600
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    R3PM is being read as Row 3 Column PM (in R1C1 notation)

    You need to use something like : _R3PM

  5. #5
    New Member
    Join Date
    Oct 2018
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    Quote Originally Posted by Bob VH View Post
    Hi Roy,

    You can't use the uppercase and lowercase characters "C", "c", "R" or "r" as a defined name, because they are all used as a shorthand for selecting a row or column for the currently selected cell when you enter them in a Name or GoTo textbox.

    Use an underscore (_) as first character. (_R3PM)

    Grtz

    Hi Bob, yes that's what I found in the Help too, but I thought only if using just one letter, not in the beginning of a word... It sounded so unlikely... But there is the 3 too so...

    We use _R3PM now (pitty for the formula that uses the named range name) of RPPPM :D

  6. #6
    New Member
    Join Date
    Oct 2018
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    Quote Originally Posted by footoo View Post
    R3PM is being read as Row 3 Column PM (in R1C1 notation)

    You need to use something like : _R3PM
    Ah really??!! That explains everything! Thanks!

  7. #7
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,970
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    Quote Originally Posted by footoo View Post
    R3PM is being read as Row 3 Column PM (in R1C1 notation)
    Actually, that's the slightly daft part - R3PM would not be a valid reference in R1C1 format. (cell PM1 would be R1C429)

  8. #8
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,722
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Why can't I use named range 'R3PM' ?

    Remark: this is language dependent.
    In languages other than English you might have problems for ex. with L or Z instead of R.
    Last edited by pgc01; Nov 21st, 2018 at 02:52 PM.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •