The
Range[
^] Top and Left properties are used to define the top left corner.
Width and Height should be in points instead of pixels. Use the 3/4 multiplier.
You may scale your pictures also.
Here is a short example in VBA:
Dim ws As Worksheet
Dim r As Range
Dim fileName As String
Dim pictureWidth As Integer
Dim pictureHeight As Integer
Dim shape As shape
Set ws = Worksheets(1)
Set r = ws.Cells(5, 2)
fileName = "d:\picture.png"
pictureWidth = 195
pictureHeight = 102
Set shape = ws.Shapes.AddPicture(fileName, msoTrue, msoTrue, r.Left, r.Top, pictureWidth * 3 / 4, pictureHeight * 3 / 4)
shape.LockAspectRatio = msoTrue
shape.ScaleHeight 2, msoTrue, msoScaleFromTopLeft