how to modify,save as new Named Range?

[jrsyangl]

I wish to modify an existing Named Range, say name2011, and save it as a new range, say name2012, while preserving name2011 and all references to it. I was able to do this in an earlier version of Excel but can't figure out how to do it now with Excel 2010/W7. In Excel 2002 there was an Add button in the Define window, but I can't find the equivalent in 2010. Any help would be appreciated.

Lou

[JieJenn]

If I understand your question correctly, you want to save an extra set of the old named range range?

Try

  
 ActiveSheet.Names.Add Name:="name2012", RefersTo:=Range("name2011")

[jrsyangl]

If I understand your question correctly, you want to save an extra set of the old named range range?

Try

  
 ActiveSheet.Names.Add Name:="name2012", RefersTo:=Range("name2011")

Thank you for your reply, but maybe I wasn't clear. I have dozens of name2011s, each with a different name and a different formula. I wish to generate a new set of name2012s with different formulas while still preserving the original name2011s with their formulas. For example, name2011 might be $A$1:$A$365. I want to generate name2012 as $A$366:$A$731 and keep name2011 intact. The actual names and formulas are somewhat more complicated. Being able to edit each name2011 and "save as" name2012 is reasonably efficient and less error prone than generating the new names from scratch. On my Excel 2002/XP system there is an Add button in Define Name popup window which enables me to do this. It would be a disappointment if there is not an equivalent functionality for Excel 2010.
Lou

[Paul]

In 2010, on the Formulas tab you can manually add names using the New button in the Name Manager dialog window. I wasn't aware of the ability to adjust a named range and save as another name in 2002, but if you say it's there so be it.

JJ's macro should help automate the process a bit.

[JieJenn]

The named range reflects as what the name means, "named a range" not duplicate a range of formula........

[jrsyangl]

I'm sorry, I do not understand what you mean. Let me be more explicit. I have a named range,
DataDiaCVS2011=Offset(Data!$T$5144,0,0,Ndays2011,1)
I wish to save this and also generate:
DataDiaCVS2012=Offset(Data!$T$5509,0,0,Ndays2012,1)
There are dozens of similar cases. A relatively easy and less error prone way to this is to modify the 2011 versions and save them as 2012 versions. I was able to this in Excel 2002. can I do it in Excel 2010?
Lou