Hi Andy

The problem seems to be related to the graph export. As I say, in 2010 the Runtime Error happens seems to happen because the exported graph generates a file that is 0kb, whereas running the same spreadsheet in 2007 there are no problems whatsoever.

When this problem was first reported (the file was created in 2007) but the end user is running 2010, I recreated all the graphs in 2010, however the problem still exists and seems to be unique to 2010.

I've tried numerous other file formats including jpg, but it makes absolutely no difference, so I assume this must be an excel 2010 or a visual basic bug?

Any other thoughts?