inserting an image using height and width from the properties dial

  • Thread starter Thread starter thomas donino
  • Start date Start date
T

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"
 
How about this:-

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