If cell A1 contains a ref EG "C:\ Photos\Pic1.jpg ( this could be up to
Pic200).Is it possible to insert so that Pic1 appears in cell "f1" ?

I have downloaded some code which will work but it means keeping all images
in the same worksheet. Ideally I would like to leave them all as ".jpgs" in
a separate folder.

Thanks very much