The code I'm currently working on imports a picture into Excel, resizes it, renames it, and attempts to place it in a designated range within the worksheet. No matter what I do to move the picture into the designated cell and then unselect the picture, the picture remains where it was originally pasted and stays selected. Any advice?
Current Code:
Sheets("SETUP").Select
'tempx is a designated picture file
ActiveSheet.Pictures.Insert(tempx).Select
With Selection
.Name = "Picture Logo"
.ShapeRange.LockAspectRatio = msoFalse
.ShapeRange.Height = 42.75
.ShapeRange.Width = 43.5
.Placement = xlMoveAndSize
End With
Selection.Cut
'Logo is a designated range (cell address)
Range("Logo").Select
ActiveSheet.Paste
Bookmarks