InsertPhoto macro created with Excel 2003 not working when upgraded to 2007

Hi everyone. I've seen quite a few postings that had similar problems when upgrading from 2003 to '07 or '10.

This macro was created using Excel 2003 and populated a report with pictures in column B based on the style numbers listed in column A. It used to work perfectly before, but now when I run it all of the pictures populate into the same cell. Can anyone help me figure out how to make sure it populates each row in the range instead?

Here is the code:

Please Login or Register  to view this content.

Thanks in advance for your help

I have 2007 and it's not working. All the pictures populate into the one cell.