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

    Re: Range Names (Excel 2000)

    Sounds as if you tried to enter the rangename in the cell itself, rather than in the data validation dialog (second box on the dialog)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range Names (Excel 2000)

    no, i entered it into the dialog box for validation.

    custom
    formula =rangename (mine is called rank)
    with a list of E1 or E2 or E3 as the range contents.
    And the area I have made for data entry is A1:A10 on sheet 1
    the range is called rank and given on sheet 2, in cells A1, A2, A3, A4 and A5 and is called "rank"

    thank you however, it was a good call.
    NMPadgett
    When i return to column A on sheet one to enter those values, I get the error message i listed above.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Range Names (Excel 2000)

    in the data validation dialog box, I think you need 'List' rather than 'Custom'

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range Names (Excel 2000)

    <hr>"The entry is not valid, the user has restricted values that can be entered in this cell"...
    <hr>
    Is the error message you get when you are trying to enter data that is not in the approved list. It looks like you have added validation but maybe not with the data you expected! Do you get the dropdown box in the cell where you are trying to enter data? Is it showing the data you expect? It may be that calling your range with the name of a worksheet function may be causing some confusion as well <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    HTH

    Peter

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Range Names (Excel 2000)

    <P ID="edit" class=small>(Edited by WebGenii on 16-Oct-02 00:59. )</P>I have read the following on C.L.Peasons site about no problems with validation and info being on seperate sheet for that validation if the following method is used.

    When you use the Data Validation tool, you can restrict valid inputs to the values in another range. However, the Data Validation dialog won't allow you to specify cells on another worksheet. But using a defined name, you can get around this limitation. Simply give the range containing the valid values a name, such as ValidRange, and then in the Data Validation dialog, enter =ValidRange as the Source for the validation list. Data Validation won't object, and everything will work as you expect.

    Well it's not working, and wonder if someone might be able to add to this. The above was given on:
    http://www.cpearson.com/excel/named.htm#Cheat
    Page and I would like to think it would work....when I choose this method, and do just as the paragraph above describes, I get the error message, "The entry is not valid, the user has restricted values that can be entered in this cell"...
    Any suggestions on this oversight would be appreciated.
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range Names (Excel 2000)

    I found the problem. I was using a custom format instead of a list format. Thanks for the help however, and I hope my mistake will help others. Oh, Geesh, Colin...didn't see you also answered my problem here. Thank you very much. You were on the money.
    NM Padgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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