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