Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copying sheets that have many named ranges

Status
Not open for further replies.

AELLC

Structural
Mar 4, 2011
1,339
I just attempted to copy 8 sheets of a workbook that has a large number of named data ranges, and it was very frustrating to re-name each range in turn.

Why doesn't Excel re-name all the ranges automatically as the default when asking whether the range should be re-named or keep the same names...DIST re-named to DIST1, for example.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor