I have created a macro which copies some charts from 1 workbook to
another. This is repeated for several worsheets in 1 workbook. It
completes the entire task very well, however it crashes excel after
the macro is run. It does not allow me to save the workbook. What
could be the problem? This is an urgent request from my customer and
this problem is affecting my work. Please help.

Could be many things, but try cutting the code up into smaller sections and
then step through it using the debugger.



--

Regards,
Nigel




"Arlette" wrote in message
...
I have created a macro which copies some charts from 1 workbook to
another. This is repeated for several worsheets in 1 workbook. It
completes the entire task very well, however it crashes excel after
the macro is run. It does not allow me to save the workbook. What
could be the problem? This is an urgent request from my customer and
this problem is affecting my work. Please help.

I have done that..i have split the code...however it still
crashes....actually it crashes for workbooks that have about 20+
sheets...for the others it works fine...what do i do in this case?

In which case it sounds like a memory problem. How you release memory
depends on the code used to create the objects.

--

Regards,
Nigel




"Arlette" wrote in message
...
I have done that..i have split the code...however it still
crashes....actually it crashes for workbooks that have about 20+
sheets...for the others it works fine...what do i do in this case?

I have actually not created any objects...there were charts in the
source document already. I just pick those and copy them to the other
blank workbook. ... so i dont have any objects in my macro as
such....should i go ahead and blank out the charts that i reference?
by mapping them to =nothing.?