Exporting a range of cells as a picture

[robert_woodie]

Is it possible to export a range of cells as a jpg picture file, usin
vba script?

Thanks
Rober

 

[Ron de Bruin]

See this page Robert
http://www.mvps.org/dmcritchie/excel/xl2gif.htm

 

[John Taylor]

Robert,

Download the file "PastePicture.zip" from the page on the right side (need
to scroll down a bit) at the following URL:

http://www.bmsltd.co.uk/Excel/Default.htm

HTH

Cheers,

John

 

[Stephen Bullen]

Hi John,

Download the file "PastePicture.zip" from the page on the right side (need
to scroll down a bit) at the following URL:

http://www.bmsltd.co.uk/Excel/Default.htm

FWIW, my URL has changed to bmsltd.ie, so the file is now at:
http://www.bmsltd.ie/Excel/Default.htm

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie