Hi nagaguru and welcome to the forum,

Do you know about Dynamic Named Ranges? Will this solve your problem?
See:
http://www.ozgrid.com/Excel/DynamicRanges.htm
or
http://www.bettersolutions.com/excel...G820716330.htm
or
http://www.decisionmodels.com/optspeedf.htm