inserting an image using height and width from the properties dial

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"
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop through pages and insert header image 0
The size of the ActiveX ListBox control shrinks 2
inserting a jpg file 4
Place picture in Excel cell 0
Table Preferred width is changed when pasting 1
image insertion height problem 2
ActiveX Properties missing from menu 2
Extract image paths from within html in a column 1

Top