that site is very helpful. thanks again!!

"Dave Peterson" wrote:

Or maybe use a dynamic named range that grows or contracts with your data.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

chris31849 wrote:

i have named a range of cell for validation use but i need to expand the list
so i need to either figure out how to expand the named range or delete the
named range and start over. thanks in advance for any replies on this.

--

Dave Peterson