Macro to insert url images into cell ?

Hi all, new here, and haven't found anything on this, so any help is appreciated !

I'm trying to insert an image from a list of url address I've populated in one column into a neighbouring column.

I'd like to loop this so it goes to the next cell down and does the same (i.e. look to the neighbouring cell on the left, insert image {i.e. click insert>picture>from file}, move down, look to neighbouring cell on left ..... )

I've created the following (which works for one cell), but it copies the original url (which vary in length per item), and simply pastes it again in the original cell.

Any help ?
jkm

***EDIT***
I guess I'm looking for how to have the macro pick new urls every time (you'll note in the code it has an actual url ... I need a new one for each new cell it will examine).
***********

Please Login or Register  to view this content.

The attached file...(which DOES contain VBA)...sequentially references the links in a selection and imports the associated image.

Is that somethng you can work with?

Welcome to the forum, jkm.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

They were indeed, thank you.

It works when it is fetching the image from the web example, but not when I try it from my own folder.
I have checked the validity of the link, but all I get is: Error loading C:/Users/Myname/Documents/blablabla... in the cell next to my selected hyperlink where I'd expect to see the image.

I'm certain that it is not the macro, as it works as a dream with the webbased image. So there must be something preventing it in the folder. I've made sure that the folder is free to be editted.

Anyone here knows what it might have caused it?

Please forgive me if I fail to answer any possible solutions for the coming 2 weeks, as I'll be on vacation starting tomorrow.
Thanks

That's a fairly old file, written for Excel 2003.
Try this later version:
Convert_CellFilePaths_to_Cell_Pics_v2d.xlsm

Is that something you can work with?

is there a newer version of this code for mac 2011? I cant get it to work

I get this error

Error loading http://www.contextures.com/images/am...AA_SL160_.jpeg