"ramana" wrote:
.. How can extend rows/columns for these named ranges.

Another option is to use dynamic ranges

Try Debra's nice coverage on this at her:
http://www.contextures.com/xlNames01.html#Dynamic

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--