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