Save a Range of Cells as Gif???

[hce]

Dear All

This question is an extension to what I've seen in john's websit
(www.j-walk.com)... There was this fantastic code which John ha
developed... Basically it took the chart and save it as a gif and henc
enabling the chart to be displayed in an userform...

My question here is whether we are able to apply the same principle t
a range of cells...??? I tried to modify the code but due to my lack o
vb knowledge i was not able to... Does anyone have an
clue/suggestions...???

cheer

 

[Tom Ogilvy]

Only a chart has an export method. You can use the same method, but you
have to copy the cells as a picture, then paste them in a blank ChartObject,
then use John's method. Harald Staff wrote routine to do this and it is on
David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/xl2gif.htm