I have at least 100 product numbers, so I will have to select the file for each one? Is there a work around? The code I posted, did that for me, it just stopped working when it came across a product number that wasn't in the folder or that was saved as a Jpg. I want to have the code skip those instances and go to the next cell.

Quote Originally Posted by Logit View Post
.
If you have more than one image, choose OPTION 2.

That will present the FILE MANAGER window from which you can select which image should be placed in a specific cell.
Then you can run the macro again and select a different image for another cell ... etc. etc.

If there is only one image, you could choose OPTION 1 and hard code the path to the image but why would you ? It is
easier simply to select OPTION 2.