copy/move sheets within workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
| 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Merge Multiple workbook sheets into one workbook 0
Copying Tab within a Workbook 1
ERROR 2
HELP - A formula or sheet you want to move or copy contains the name .... 0
Move/Copy sheet to another workbook error 2
Copy worksheet containing names to other workbook w/o problems? 1
problems getting this macro to work 23

Back
Top