Named Ranges

[keith]

I have a file with over 100 named ranges. I would like to
expand the range of the name on all of these names. Is
there a way to use the replace command or is manually the
only way to do this?

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to keith.
Please use the newsgroup for further discussion.]

If the names refer to hardcoded ranges, i.e., Name1 =Sheet1!$A$2:$A$5
then you will have to either fix them by hand or write a VBA program
that will make the change(s) you need.

Alternatively, you use named formulas that adjust as needed. Suppose
you have data in a single contiguous range in column A starting with
A2. Then, Name1AutoFix =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),1)
will select all the data and adjust itself as more data are added.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions