Thread: Range Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N.F[_2_] N.F[_2_] is offline
external usenet poster
 
Posts: 65
Default Range Question

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")