I'm running Excel 2003 SP2 on a Win 2000 Pro system and after nearly a
month of development my code occassionally stops working!

I am using a macros to copy a hidden sheet with graphs based on a pivot
table, rename the copy, and change the row field of the copied pivot
table (which changes the graphs). I use 19 of these macros to graph 19
different subjects (or row fields) each on their own newly created
sheet. If the macro is rerun it asks the user if they want to keep the
old sheet or delete and rerun. I don't beleive I've ever had a problem
running the 19 macros individually (save one, which inconsistantly
changes graphs from plotting by columns to rows).

I also have a macro which runs all 19 macros at once. The first time I
run that macro all 19 work fine. However if I rerun the "all" macro
some of the 19 work and others don't. Same problem if I run any of
the 19 individually after running the "all" macro. Which of the 19 to
have problems is not conistant nor are the problems. When I step into
the macros they either work fine or stop half way through (the macro is
no longer playing an a number of stops where never hit).

I have disabled "Auto Scale" fonts on the graph area formates. I have
also try to prevent file fragmentation by rebuilding the file without
macros and copying and pasting my code into the new file.

I've tried everything I can think of, spent days search the web, and am
now considering a month of work wasted. What is going on with my
file/code?

Thanks for any help you can give!

Teilen