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.