Changing the name of a list.

[comotoman]

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?

[swatsp0p]

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 Name>Define...

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

HTH

[comotoman]

This works very nice, thanks very much.

[swatsp0p]

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

Cheers!

Bruce