I am attempting to copy a sheet that has several named ranges. Each time I have to select whether to keep the names as defined or rename them. Is there a setting that will override this and keep the ranges each time I copy the sheet. Thanks
I am attempting to copy a sheet that has several named ranges. Each time I have to select whether to keep the names as defined or rename them. Is there a setting that will override this and keep the ranges each time I copy the sheet. Thanks
1. AFAIK, this type of 'conflicts' arises -only- when you are copying:
a) formula between worksheets [same workbook] with identical names
b) worksheets into other workbooks that has identical names
2) For named-ranges they have two scopes:
a) global [workbook-level] as the first time you define/create/... the name
b) local [worksheet-level] when you copy worksheets within the same workbook [or fully-qualifying with the sheet-name while defining the name]
3) When you copy entire worksheets within the same workbook excel [usually] can *handle* this issue creating a *new* set of local names referring to the *new* sheet if you are performing actions as per 1-a) and/or 1-b) [i guess] you could use macros setting to false Application. DisplayAlerts turning it back to true after completing your copy-actions.
Bookmarks