Hi, i am looking for some VBA code to resolve an url image name in CELL A1 to A1000 and place the image in a new cell next to it. If the image does not exist then no image is displayed.
This is what i have so far..
Please can anyone help?
Many thanks
Brian
This is what i have so far..
Code:
Sub Test()
Dim objPicture As Picture
For i = 2 To 100
With Sheet1.Cells(i, 9)
Set objPicture = .Parent.Pictures.Insert(Sheet1.Cells(i, 1).Value)
objPicture.Top = .Top
objPicture.Left = .Left
objPicture.Height = 150
objPicture.Width = 150
End With
Next i
End Sub
Please can anyone help?
Many thanks
Brian