I use following lines to import two pictures into a worksheet:
With ActiveSheet.Pictures
.Insert ("http://www.abc.com/picture1.jpg")
.Insert ("http://www.abc.com/picture2.jpg")
End With
Both pictures are too big; also the placement of the pictures is rather
haphazard.
Would appreciate it if someone could me how to:
- place picture1 somewhere near to cell A1 and picture2 near to cell A20.
- resize height of picture1 to 3 inches
- resize width of picture2 to 4 inches
TIA.
Bookmarks