Copy range and paste as picture
 

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

Copy range and paste as picture
 

On Mon, 28 Apr 2008 11:52:17 -0700 (PDT), jlclyde
wrote:

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


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

Lars-Åke

Copy range and paste as picture
 

On Apr 28, 2:22*pm, Lars-Åke Aspelin
wrote:
On Mon, 28 Apr 2008 11:52:17 -0700 (PDT), jlclyde

wrote:
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

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

Lars-Åke

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