Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    103

    Unanswered: change in range for namebox

    Hi all,

    I wish to know if there is a way to change the range for a defined namebox,
    for eg. my namebox1 is set to have range from A1:A10, now i need to reset it to A1:A20, is that possible?

    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    I feel sure it is, but what is a namebox ?

    MTB

  3. #3
    Join Date
    Feb 2006
    Posts
    113
    Not clear on your requirement. Is a namebox a defined name? Then
    Code:
    Range("A1:A20").Name = "namebox1"

  4. #4
    Join Date
    Jun 2006
    Posts
    103
    Oh...sorry, i should have explain more, namebox is the text box on top of column A (at the top left corner), if you select some range of cells, then put a name there, then next time excel will link the name to that particular range that your have selected, however, so far i never find a way to edit the range, i can only create it. but dont know how to edit nor delete.

    Usually i seldom use this name box, is just that the previous programmer has use this name box which a lot of function use the namebox, in order to modify the functions one by one, i hope i can edit the range of the namebox.

  5. #5
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi again

    Now we know what youe are talking about ...

    As Fazza indicated, if you are using code then
    Range("A1:A20").Name = "namebox1"
    will do it.

    If you are working in/on the sheet then try

    Insert -> Name -> Define

    on the menus and select/specify the name and range you require !

    HTH

    MTB

Posting Permissions

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