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.
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.
