Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
range name does not exist
have a macro which is used to copy a sheet from workbook "B" into workbook
"A". The destination workbook may have multiple sheets which have been copied in from workbook "C" using a similar macro. Each instance of a sheet from workbook "C" contains a range named "CONSTRUCTION". Excel seems quite happy with this, and identifies each instance of the named range via it's respective sheet name. However, if I copy a sheet from workbook "C" to workbook "A", and then copy a sheet from workbook "B" to workbook "A", I get an error message; "A formula or sheet you want to move or copy contains the name 'CONSTRUCTION', which already exists on the destination worksheet. Do you want to use this version of the name?" The problem is that the sheet from workbook "B" DOESN'T contain a name of "CONSTRUCTION". It only has one named range (print_area). There were two incidents of the word 'construction' in a text field (which is the result of a concatenation formula), but I have tried removing these and still get the same problem. Is it possible that there is some file corruption at work? If so, how would I check for it? Any suggestions / help gratefully received! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
range name does not exist
Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It'll make it much easier to verify your names. scory wrote: have a macro which is used to copy a sheet from workbook "B" into workbook "A". The destination workbook may have multiple sheets which have been copied in from workbook "C" using a similar macro. Each instance of a sheet from workbook "C" contains a range named "CONSTRUCTION". Excel seems quite happy with this, and identifies each instance of the named range via it's respective sheet name. However, if I copy a sheet from workbook "C" to workbook "A", and then copy a sheet from workbook "B" to workbook "A", I get an error message; "A formula or sheet you want to move or copy contains the name 'CONSTRUCTION', which already exists on the destination worksheet. Do you want to use this version of the name?" The problem is that the sheet from workbook "B" DOESN'T contain a name of "CONSTRUCTION". It only has one named range (print_area). There were two incidents of the word 'construction' in a text field (which is the result of a concatenation formula), but I have tried removing these and still get the same problem. Is it possible that there is some file corruption at work? If so, how would I check for it? Any suggestions / help gratefully received! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions |