Results 1 to 11 of 11
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Define Name (office 97 SR2)

    I am trying to define a cell name R252 FRP But Excel tells me that the name is not valid, I think it is due to it beginning with R because I cannot name a cell with a single R.

    Can anyone help please
    If you are a fool at forty, you will always be a fool

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    You cannot include a space in a range name, but you should be able to use R252_FRP, however I tested it and found that excel did not like it, though it has no problem with A252_FRP. Maybe there is some conflict somewhere.

    You could try _R252_FRP if you cannot get R252_FRP to work.

    Andrew C

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Define Name (office 97 SR2)

    Thanks very much Andrew, What you say it true but it's still a mystery yeah! This a car registration so I would like it to be correct However we can't always have what we want
    Regards Braddy60
    If you are a fool at forty, you will always be a fool

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    XL2K OLH says this:

    Guidelines for naming cells, formulas, and constants in Microsoft Excel
    What characters are allowed? The first character of a name must be a letter or an underscore character. Remaining characters in the name can be letters, numbers, periods, and underscore characters.

    Can names be cell references? Names cannot be the same as a cell reference, such as Z$100 or R1C1.

    Can more than one word be used? Yes, but spaces are not allowed. Underscore characters and periods may be used as word separators
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    Jan,

    None of that seems to explain why A252_FRP or A252FRP is ok, but R252_FRP or R252FRP are not, or at least I cannot get excel to accept them. Any ideas ?

    Andrew C

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Define Name (office 97 SR2)

    I would imagine it doesn't like the R because of the "R1C1" notation, i.e., when it finds the letter R followed by numerics it thinks you're trying to refer to a cell by its row and column numbers.

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    A single R or C followed by a number at the beginning of a name is illegal because it confuses Excel into thinking it is an R1C1 reference.
    Legare Coleman

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    I take the point Legare, but as there are non numeric characters after the numbers. I would have thought Excel could resolve it.

    Thanks

    Andrew

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    The code may get confused before it realizes that there are characters after the number. This might also be a holdover from an easy fix to some problem in the code many releases ago.
    Legare Coleman

  10. #10
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    yeh, it's the Rn or Cn where 'n' is a number that Excel chokes on. I have lots of names that start with C but they do not also have numbers. If it even looks like it could be a cell address, it's invalid.

    Deb

  11. #11
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Define Name (office 97 SR2)

    I just can't understand why XL does not see if the name is a valid range, and if not allow it. It is quick enough to pick up an an invalid range name used in a formula or code.

    Enter =R252FRP, and it is rejected. Programmer laziness I'd say.

    Andrew

Posting Permissions

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