You can set up a dynamic named range which automatically adjusts if
you add more values to it - Chip Pearson explains how he

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

and Debra Dalgleish also explains this he

http://www.contextures.com/xlNames01.html#Dynamic

Hope this helps.

Pete

On Jul 27, 11:48 pm, N.F wrote:
If I have a named range for instance $A$11 : $C$14 = Range("TEST")

and I want to add any more values to this range how can i make it so that the
user can add more values which are outside this range and have the range
automatically change to capture the newer values as well in the same named
range("TEST")