Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When I try to copy sheets in a workbook to another sheet in the same workbook
I get the following error message: A formula or sheet you want to move or copy contains the name 'aa', which already exists on the destination worksheet. This repeats many, many times until it ends with something like 'zzzzzzzzzzz'. How can I preclude this from happening? I don't have any named ranges in the sheet/workbook that this occurs in. Has anyone seen this? |
#2
![]() |
|||
|
|||
![]()
I don't have any | named ranges in the sheet/workbook that this occurs in.
Yet Excel thinks you do. Grab the Names Manager utility just to make sure there are no hidden names. Yes, they can be hidden and not show in the Define Names dialog. http://www.jkp-ads.com/Download.htm -- Jim "Roger B." wrote in message ... | When I try to copy sheets in a workbook to another sheet in the same workbook | I get the following error message: | | A formula or sheet you want to move or copy contains the name 'aa', which | already exists on the destination worksheet. | | This repeats many, many times until it ends with something like | 'zzzzzzzzzzz'. How can I preclude this from happening? I don't have any | named ranges in the sheet/workbook that this occurs in. Has anyone seen this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Numbering sheets in workbook | Excel Worksheet Functions | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |