inserting an image using height and width from the properties dial

[thomas donino]

I would like to insert a .jpg file into a range on my worksheet BUT i want to
insert it at a specific size as defined by the height and width properties in
the properties dialog of the image when I right click it and select
properties. For instance H=.68"
W=2.07"

 

[Alan Moseley]

How about this:-

Range("C9").Select
ActiveSheet.Pictures.Insert("C:\mypicture.jpg").Select
Selection.ShapeRange.Height = 70.5
Selection.ShapeRange.Width = 105.75