A question from Chris:
[W]hat I would like to do is paste (link) a web image into a cell, the choice of web image dependent on another cell.
Eg. A1=îimage1î, paste http://web.com/image1.jpeg into A2
Here’s a macro that uses the AddPicture method of Shapes collection object.
Dim sPicPath As String
sPicPath = “/blogpix/” & _
.Shapes.AddPicture Filename:=sPicPath, _
The end result looks like this: