Worksheet copy problem

[Steven]

Hello,

I have a particular worksheet that is giving me an error
when copying. Below, I'll try to explain this the best I
can....

I right click Worksheet Tab and choose 'Move or Copy'.
I choose to create a copy within the same worksheet.

The first copy goes fine but if I try to copy the copy,
I'll get the following error:

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

The error box has a Yes and No button which lets me either
rename or use the name as defined in destination sheet. I
have been choosing to use name as defined on destination
and it doesnt seem to have any effect on the sheet.

I have searched everywhere I can think of within the
spreadsheet to try and find anything with 'AGAIN' in it. I
find nothing. Has anyone encountered this and possibly
have a fix? It is very annoying to deal with.

Steven

 

[Andy B]

Hi

It sounds like you have named a cell or range and called it AGAIN. Go to
Insert / Name / Define and see if there are any names listed in the box.
Excel can only have one occurence of a name per workbook, although you can
have Sheet1joe and Sheet2joe, for example.

 

[Steven]

Hello Andy,

Thanks for quick reply. This was the first thing I checked
also. Sorry I didnt mention it in my initial post. I have
no named cells or ranges at all. Thats the puzzling thing.

Let me also add the following...

I get a series of the same message but with different
names. They are...

AGAIN
FINDME
HELP
PLEASE

I thought it may be some type of virus but havent found
anything when i searched.

Steven

 

[Andy B]

Do you have any VBA modules that could cause this?

 

[Steven]

I have no modules attached to this worksheet. I even
removed the one I have startup when Excel starts. I am
pretty sure I covered all the normal bases. I was hoping
to find some odd issue that would lead me to a resolution.

Steven