inserting an image using height and width from the properties dial
 

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"

inserting an image using height and width from the properties dial
 

How about this:-

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

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"thomas donino" wrote:

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"