Moving pictures in excel from one sheet to another

  Desert Andy 09:32 02 Oct 07

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 07

any ideas

  robbiepaul79 11:27 02 Oct 07

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 07

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 07

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 07

Thank you!

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5