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

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26374

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

--
Regards,
Tom Ogilvy

"hce" wrote in message
...

Dear All

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

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

cheers


--
hce
------------------------------------------------------------------------
hce's Profile:
http://www.excelforum.com/member.php...fo&userid=3518
View this thread: http://www.excelforum.com/showthread...hreadid=263744