Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep names defined after a copy?
Hi,
I have defined a sheet model, which contains several defined names. Some of these names are used in formulas in cells of the same sheet and the remaining names will be used later when this model is copied to one other workbook. When I copy this model, by program using VBA Copy and Paste commands, I lost all defined names which are not used in the same sheet of the model, and the others names remain defined. Why Microsoft Excel removes these names ? Is there any solution to keep these names defined after a copy? Thanks for any suggestion. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
Rename Defined Names | Excel Worksheet Functions | |||
How to delete all defined names from a workbook? | Links and Linking in Excel | |||
copying cell names | Excel Discussion (Misc queries) | |||
How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) |