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

Hi

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

MTB

Not clear on your requirement. Is a namebox a defined name? Then

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.

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