When copying sheet I get this error

**JK1234** · 08-05-2009, 10:57 AM

This is the error i get by doing> edit> move or copy sheet

A formula or sheet you want to move or copy contains the name 'HTML', which already exists on the detination worksheet. Do you want to use this version of the name?

All I want to do is copy a sheet into the same book. If I click yes, two more errors pop up.

Suggestions????

**NBVC** · 08-05-2009, 11:16 AM

If you go to Insert|Name|Define check that you don't have a named range containing HTML... if you do, you may need to delete before copying as it might be causing the conflict by duplicating that named range.. which is not allowed.

**JK1234** · 08-05-2009, 11:22 AM

I checked this and there are no defined names???

**JK1234** · 08-05-2009, 11:24 AM

If I clikc okay I get three errors:

'HTML'
'HTML_Control"
'JJ_Menu'

I need the page to copy itself when someone clicks on a macro without asking this. If I say yes, yes then yes then it will copy the page.

?????

**NBVC** · 08-05-2009, 11:38 AM

Paste this in your google search field:

"A formula or sheet you want to move or copy contains the name"

and check the multitude of hits... I am not sure which one best suits your situation.

**JK1234** · 08-05-2009, 12:09 PM

This seemed to work:

http://www.oaltd.co.uk/mvp/

I used the addin manager...have to check and see if everything on the page still works properly. It found alot of named ranges where the excel 2003 did not.

Thank you!

**NBVC** · 08-05-2009, 12:14 PM

Great, glad you found something useful..

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**JK1234** · 08-06-2009, 10:10 AM

You beat me to it.Thanks

I wanted to see if it would work. It did work but now after testing last night.
I have another problem with it. But his EXACT issue has been fixed - just have a new one related. I will start a new thread.