VBA to insert picture

Hello all,

I'm looking for some help please.

I am trying to get the code to loop through each row on the "front page" sheet, get a picture name, look in the chosen directory & if found then insert it in another sheet.

Sheet names are based off the values in column 1, so as the code looks for the picture name in the first row (starting at row 4) column 19, it will then look for that worksheet name based on the value in column 1 (starting at row 4), go to that sheet and paste the picture at F26, then go to the next row until it gets to the end of the rows. I'm not that clued up on VBA and this is what I have ended up with, however it doesn't work! I get no errors, but no picture either.

Would any of you be willing to help at all?

Please Login or Register  to view this content.

Hi Bakerman2 / Jolivanes

Thanks for the help.

I tried both the codes and they do as required. However, sometimes they wont always have a picture name in the column & I have noticed that if one line is empty, it breaks the code. Is there anyway we can get this to either, insert "no photo found" for the blank cells or no file name that matches the column data and/or skip that row if no picture name is present?

Regards

Change this part

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Jolivanes,

I tried the change but I get a "Run-time error '1004' Unable to get the Insert property of the Picture class" at

Please Login or Register  to view this content.

Also, how would I change the size of the screenshot with your code?

Thanks Jolivanes

Read the first 5 lines of Post #4 again. Also make sure there are values in Column A where there are Values in Column S (=19).
If all else fails, attach your Workbook without data we don't need to know (names, addresses and whatever).

Try changing this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

@ b.amarkhail
Please start your own thread.

Hi Jolivanes

thanks for reply;

i am new to this forum; i did not understand what do you mean by start my own thread;
please if you make it more clear, i am not professional in English.
thanks

Restart by reading first the forum rules …

Just think for a minute. If everybody did the same as you, there would be just ONE thread with thousands of different problems. How would you ever find anything at all.
What you did is called hijacking because you take over someone else's thread. That's why you need to start your own with a proper heading and a clear explanation of what you want.
It looks like it would be advantageous to attach a workbook with a before and after scenario. No personal info like real names, real addresses etc etc.