Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a formula or sheet you want to move or copy contains the name xxx
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
a formula or sheet you want to move or copy contains the name xxx
hi, michelle !
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? 1) AFAIK, this type of 'conflicts' arises -only- when you are copying... a) formulae between worksheets [same workbook] with identical names b) worksheets into other workbooks that has identical names 2) 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 -?- hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy or cut multiple rows to move to new sheet? | Excel Discussion (Misc queries) | |||
move or copy sheet | Excel Worksheet Functions | |||
when i move or copy a sheet, dates change by one day?? | Excel Discussion (Misc queries) | |||
Copy Sheet and move to end | Excel Discussion (Misc queries) | |||
How do I move or copy more then one sheet at a time | Excel Worksheet Functions |