Thread: inserting an image using height and width from the properties dial
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Moseley Alan Moseley is offline
external usenet poster
  
Posts: 75
Default 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"
Reply With QuoteReply With Quote