Copy range and paste as picture

J

jlclyde

In excel you can copy something and then click Shift + Edit to chose
paste as picture. What is the VBA equivelant of this. The reason
that I am wondering is that the range that I have changes sizes and it
needs to fit into an area that can not change sizes. I know I will no
longer be able to perform data manipulation on it but that is ok. I
just need the picture.

Thanks,
Jay
 
L

Lars-Åke Aspelin

In excel you can copy something and then click Shift + Edit to chose
paste as picture. What is the VBA equivelant of this. The reason
that I am wondering is that the range that I have changes sizes and it
needs to fit into an area that can not change sizes. I know I will no
longer be able to perform data manipulation on it but that is ok. I
just need the picture.

Thanks,
Jay
Click to expand...


The easiest way to find out is to record a macro while doing the
copying/pasteing.

Lars-Åke
 
J

jlclyde

The easiest way to find out is to record a macro while doing the
copying/pasteing.

Lars-Åke
Click to expand...

Lars,
I thought I had tried that with this problem. Apparently I was
wrong. It worked great and now i have a module setup to copy and
paste as a picture.

Jay
 
Top