You can directly edit the cell references by going Insert-Name-Define and
making the changes in there.


--
Regards,
Dave


"ramana" wrote:

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