Copy Height and Width to another autoshape

[OutlawoftheMarsh]

I'm dealing with a lot of pictures and autoshapes. Sometimes I need to create an autoshape that's the same size as a picture that has already been inserted by someone else. Is there any easy way to automatically size the new autoshape the same as the picture that's already there?

 

[BrianB]

The Top,Left,Height and Width properties are the ones to use.

Have a look at my code here

http://www.mrexcel.com/forum/showthread.php?t=271794

There is a little routine at the bottom that shows size/positions of shapes in a worksheet. So you run it to find out what the position is and give your shape the same properties.