Insert multiple Photos MACRO

Hello all,
I use the following macro (found it in a forum) below to insert photos in Column A of my worksheet and it works great!
But I need a MACRO that will load hundreds of photos all down Column A. what code needs to be added in order for that to work? Im just a novice and have been searching for a Macro I can copy that will let me load hundreds of photos automatically. Thank you!!

Please Login or Register  to view this content.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

So how do you want to select these hundreds of pictures to insert?

I have them all in one folder in the My pictures folder in my c drive and would like to insert them starting from Cell A2 and just get loaded all down column A (my photo column). The images are already compressed for document viewing. The number of images I insert will vary for each photo inventory document I need to create. Hope that's helpful.

Please Login or Register  to view this content.

Thank you for this code Shg.
IT WORKED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I cant thank you enough! at first it didnt work but then I double checked my path and made some changes and it works! Im so relieved that I wont have to drag and drop 1000 photos one by one!

If I may inquire further, is there any way to retain the original photo file name when it gets inserted into the worksheet so that it can be read in the Name Box above column A.
And finally I am wondering how the code you wrote for me could be slightly adjusted so that the images are just a little smaller than the cells the are in. As they are now they overlap the cells and thus will not move when I do a custom sort of my worksheet.

Thank you again so much for your assistance I appreciate it so much!

Racquel Casinsinan,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.