Edit Named Ranges

[monagan]

I have a Named Range, Alaska, with the cities in Alaska
I need to add more cities, so I need to change the range to includ
more cities.

Also I have a named range, Alabama, with cities in Alabama.
I need to delete cities, so I need to change the range to include les
cites.

Any Advice or hints?

thank You in advanc

 

[JE McGimpsey]

Try dynamic ranges:

http://cpearson.com/excel/named.htm#Dynamic