Please help! I am using VBA in Excel XP with Windows 2000.

My program pastes a picture of a spreadsheet into a clean
sheet and then rotates the image 90 degrees.

Now I need to:

1. Programmatically always move the image (after rotating)
to the upper-most left-hand corner (so it covers
cell "A1"). Recorded code always uses "increment" and this
is not always uniform in result due to different sized
images. So, how do you do this?

2. I need to programmatically scale the image to fit on
one page (without scaling the entire document). How can I
calculate the scale size and resize the image
proportionately?

Your example code would be extremely appreciated. Thanks
in advance...