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.

Hi

Go to Insert / Name / Define and edit the range in there.

Andy.

"chris31849" wrote in message
...
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.

"chris31849" wrote in message
...
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.

Select your new range. Click Insert, Name, Define and enter the same name as
before. That will overwrite Excel's recognition of the previous range.

You can change it in the Define Name dialog. Change the range in
the "Refers to" text box.

With code, you can change the number of rows to which the name
refers to with code like

With ThisWorkbook.Names("TheRange")
.RefersTo = .RefersToRange.Resize(10, 1)
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"chris31849" wrote in
message
...
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.

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

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