I've been working on financial analysis progam which inputs data from two
Excel files and outputs to three multi-tabed Excel files.

I've been working on several macros to perform than analysis over the past
4-weeks. (The program is ~2,000 lines and I wanted to break into multiple
macros so its easier to debug.)

I began getting a new error today, and it is occuring in a part of the
programs that I have not recently modifed.

When copying worksheets from the main program file to an output file, I now
get the following error is a messagebox with Yes/No response buttons:

"A formula or sheet you want to mover or copy contains the name
'NamedRange', which already exists on the destination worksheet. Do you want
to use this version of the name?
-To use the name as defined in the destination sheet, clidk Yes.
-To rename the range referred to in the formula or worksheet, click No, adn
enter a new name in the Name Conflict dialog box."

I don't know what this error means.
If I click Yes - it proceeds normally until the next time the program wants
to copy another sheet. If I click No, I get a dialogue box asking me for a
new name. If I type in a new name it still proceeds using the old name and
seems to ignore the new name altogether.
I don't have any variables named 'NamedRange'.

I'm beginning to think my main program file is corrupt, or that an Excel
file is corrupt.

--
Richard