Copy range and paste as picture

[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

 

[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

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

Lars-Åke

 

[jlclyde]

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