software

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.

quot;chris31849quot; gt; wrote in message
...
gt;i have named a range of cell for validation use but i need to expand the
gt;list
gt; so i need to either figure out how to expand the named range or delete the
gt; named range and start over. thanks in advance for any replies on this.
quot;chris31849quot; gt; wrote in message
...
gt;i have named a range of cell for validation use but i need to expand the
gt;list
gt; so i need to either figure out how to expand the named range or delete the
gt; 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 quot;Refers toquot; text box.

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

With ThisWorkbook.Names(quot;TheRangequot;)
.RefersTo = .RefersToRange.Resize(10, 1)
End With--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;chris31849quot; gt; wrote in
message
...
gt;i have named a range of cell for validation use but i need to
gt;expand the list
gt; so i need to either figure out how to expand the named range or
gt; delete the
gt; named range and start over. thanks in advance for any replies
gt; 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:
contextures.com/xlNames01.html#Dynamic

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

--

Dave Peterson

that site is very helpful. thanks again!!

quot;Dave Petersonquot; wrote:

gt; Or maybe use a dynamic named range that grows or contracts with your data.
gt;
gt; See Debra Dalgeish's site for some nice tips:
gt; contextures.com/xlNames01.html#Dynamic
gt;
gt; chris31849 wrote:
gt; gt;
gt; gt; i have named a range of cell for validation use but i need to expand the list
gt; gt; so i need to either figure out how to expand the named range or delete the
gt; gt; named range and start over. thanks in advance for any replies on this.
gt;
gt; --
gt;
gt; Dave Peterson
gt;