Moving pictures in excel from one sheet to another

  Desert Andy 09:32 02 Oct 2007

I am trying to move a picture from one sheet to another, by copying and pasting. However, each picture seems to move to a different position in a selected cell. Is there a way of moving a picture to the top left of the worksheet so that I have a base to start from and then I can move every picture to the correct position in the worksheet.


  Desert Andy 11:23 02 Oct 2007

any ideas

  robbiepaul79 11:27 02 Oct 2007

mmm when i insert a picture i can move it aroound the document without any problems, ill try and recreate your error if i can and get back to you

  Desert Andy 13:16 02 Oct 2007

I am moving the pictures using visual basic, so I want to take away any control from the outside user.

  VoG II 17:00 02 Oct 2007

Try something like this after the paste operation

With Sheets("Sheet1").DrawingObjects("Picture 3")
.Top = 0
.Left = 0
End With

  Desert Andy 19:24 03 Oct 2007

Thank you!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017