Question Inserting Picture in Excel

[roberttran52002]

Hi All,

I have a list of picture file names on column A and would like to have a cript to insert all the pictures to the respective rows of column B.

ie. A1=c:\pic1 ==> pic1 will be inserted to B1

A2=c:\pic2 ==> pic2 will be inserted to B2

Thank you very much for any advice!

Robert

 

[Atomic Shrimp]

I just tried recording a macro while I inserted an image, but when I looked at the code, it hadn't recorded anything there. I'm wondering if this means that particular function can't easily be automated.

Also, you can't actually insert an image into a cell - it floats on top of all the cells. Not sure if that would be a problem too.