Hi,

I have a workbook that has a load of macros built into it doing all sorts of
things, but primarily it is concerned with producing a set of charts based on
data imported from another source. There are three main macros:
1) One imports all the source data to a specific place.
2) One populates the various charts.
3) One populates a Word document with a pre-defined selection of these charts.

Each macro is triggered by a different button click.

Each macro works as a standalone piece of code and produces the outputs I
want. However, if I run macro 2) (populate the various charts) then
immediately run macro 3) (populate the Word document) XL closes sompletely,
with no error messages/warnings.

If I run macro 2), save the file and then run macro 3), everything works fine.

can someone please explain in simple terms (I'm not a programmer, I'm
learning the basics of coding as I go along) how I could go about finding
what is causing the code to crash?

TIA

Dave