Hi,

I have a worksheet with a column of hyperlinks to pictures
(http://server/image.jpg, http://server/image2.jpg, etc.)

I would like to create a macro which replaces all the hyperlinks with
the actual pictures, or inserts them into an adjacent cell.

I can easily loop through the hyperlinks with

For Each h In Worksheets(1).Hyperlinks

but I have not found a way to replace these links with the images they
are linking to.

I haven't found how to get the cell address of my hyperlinks either.
h.Address returns the web address, not "RxCy" as expected.

(and if possible, I would like to grow the cell's size to accomodate
for the size of the picture once it is downloaded).