Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error suddenly started occuring
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal macro file will not pull up when excel is started | Setting up and Configuration of Excel | |||
Stop Getting Started task pane from launching in Excel | Excel Discussion (Misc queries) | |||
getting started pane | Excel Discussion (Misc queries) | |||
Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Getting started pane | Excel Discussion (Misc queries) |