Changing the name of a list.
 

i have created list names next to the formula bar, but i need to edit
the lists (to add more to the list) How do I delete, or change my list
names?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=468324

If you insert cells (rows or columns) <within the named range, they
automatically become part of the named range (it auto adjusts the
boundaries of the range).

Alternatively, you can go to Insert on the main menu and choose
NameDefine...

select the desired range from the list and adjust the defined range in
the "Refers to:" box to meet your needs.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468324

This works very nice, thanks very much.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=468324

Glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468324