Andy,

Nice list. Thanks for responding. Upon reflection, I am guessing you used
a dummy format argument to test for no graphic filter (my bad <g).

--
Regards,
Tom Ogilvy


"Andy Pope" wrote:

Hi Tom,

No filters would not produce the 91 error. As you pointed out that's
more likely the chart not being active. A bad path also raises the 1004
error but the code would suggest that this is unlikely.

No chart active,
Error: 91 Object variable or With block variable not set

Incorrect Chartobject indexing,
Error: 1004 Unable to get the ChartObjects property of the Worksheet class

No graphic filter,
Error: 1004 Method 'Export' of object '_Chart' failed

Path does not exist,
Error: 1004 Method 'Export' of object '_Chart' failed

Cheers
Andy

Tom Ogilvy wrote:
The error would suggest you do not have the graphics filters loaded.


I originally thought of suggesting that as well, but, while I wouldn't know
how to uninstall them to test, do you really think it would evoke a Run-time
error '91':
Object variable or With block variable not set?

That didn't seem to jive with me, but I have never not had them installed.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info