Thank you very much for your suggestions
I have tried your code on a new worksheet, which work very well, and the
previous image is removed and display a right image, but when I insert the
code into my existing worksheet over 100 MB size, which the image can be
displayed, but the previous image cannot be removed.
Do you have any suggestions?
Thank you very much for any suggestions
Eric

"OssieMac" wrote:

Hi again Eric,

I found out how to Unlock / Lock the aspect ratio so you can accuratesly
align the picture within the required cells. Note that it could cause some
distortion of the picture.

With myPic
.ShapeRange.LockAspectRatio = msoFalse '/ msoTrue
.Top = dblTop
.Left = dblLeft
.Height = dblHeight
.Width = dblWidth
End With

--
Regards,

OssieMac