That code worked ok for me.

Did you remember to change the folder name? I didn't change it back after I
tested.

And it looks for names of files that are in column 9--after you inserted a new
column. So the names should have been in column 8 (H) before the code starts.

Lil wrote:

Hi Dave,

Thanks for your quick response. I guess I wan't very clear. I needed to
insert a different picture for each row in the worksheet. These pictures
are held in a directory on the c:/ drive and each row has the file name
of the picture to display.

Would the code you give me do this? Or would it just display one
picture.

Many thanks,
Lillian.

--
Lil
------------------------------------------------------------------------
Lil's Profile: http://www.msusenet.com/member.php?userid=1810
View this thread: http://www.msusenet.com/t-1870503977

--

Dave Peterson