View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default HOW TO EXTEND A NAMED RANGE

Just select and name the range again. You are not even asked if you want to
overwrite it, which I think is not a good thing, but...that's the way it is.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"ramana" wrote in message
ups.com...
Hi Everybody,

I have Named a range(say from A1 to A5),and B1to B5, C1toC5 for
dependent drop down list. and for Vlookup. now I wanted to include some
more names in the names in the named ranges. How can extend
rows/columns for these named ranges.

Thanks and Regards

Ramana