<div>
No problem!, you are welcome anytime.<br />
Thanks for the points/grade<br />
Cheers
</div>


No problem!, you are welcome anytime.
Thanks for the points/grade
Cheers

<div>
When I try this solution, I get a:<br />
<br />
Run-time error '1004':<br />
Application-defined or object-defined error<br />
<br />
Any ideas on a solution?
</div>


When I try this solution, I get a:

Run-time error '1004':
Application-defined or object-defined error

Any ideas on a solution?

<div>
well, that was a solution in Office97'Age i think. <br />
Sure you are using at least a 2003, aren't you?<br />
<br />
PD: anyway, just a guess, how many chart have you in worksheet?
</div>


well, that was a solution in Office97'Age i think.
Sure you are using at least a 2003, aren't you?

PD: anyway, just a guess, how many chart have you in worksheet?

<div>
by the way, your sheet is named &quot;sheet1&quot;?<br />
try replacing sheet1 for just 1
</div>


by the way, your sheet is named "sheet1"?
try replacing sheet1 for just 1

<div>
I am using Excel 2003. &nbsp;I have just one chart within a sheet. I tried renaming and am getting the same error.
</div>


I am using Excel 2003.  I have just one chart within a sheet. I tried renaming and am getting the same error.

<div>
i did try with excel 2007 and it continues working!!<br />
maybe, and just maybe, the error not belongs to that line of code... just a guess (without furter info i can speculate only)
</div>


i did try with excel 2007 and it continues working!!
maybe, and just maybe, the error not belongs to that line of code... just a guess (without furter info i can speculate only)

<div>
<div class="content wysiwyg-content">
I know there is a way to export charts as pictures in excel<br />
I wish to have a couple of lines in VBA<br />
that does that.<br />
<br />
thanks<br />
<br />

</div>
</div>


I know there is a way to export charts as pictures in excel
I wish to have a couple of lines in VBA
that does that.

thanks



Export to gif or jpg using excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.