I am adding an image to Excel, one image is original picture, one is updated picture, I want the original picture to stay in the exact same location, but I want the updated picture to be same heightxwidth and be offset by 4 cells. This is my syntax, but the updated picutre is keeping its height & width not updating to mirror what the original picture has?
[vba]
Set image = .Pictures.Insert("C:\" & employeename & "\" & employeename & ".jpg")
For Each Shape In ActiveSheet.Shapes
If (Shape.Name = "Old Picture") Then
Shape.Select
image.Left = Shape.Left + 30
image.Top = Shape.Top + 30
image.Width = Shape.Width
image.Height = Shape.Height
End If
Next
[/vba]