Insert multiple images into excel work sheet by name

Hello Experts
Hope I am in the correct forum section here
I have a work sheet that has in column B a list of .jpg image names (From B1 to B100)
These images are stored at C:\Users\Rob\Pictures
I want to insert the images into Column A alongside the matching name in column B

I have searched google and found many examples of code to do this but with my very limited code knowledge have been unable to modify it with my specific criteria and make any of them work for me.

What I would like from some very helpful person out there is the code exactly as I would need to write it.
That is with my exact information detailed above
Much appreciated if somebody would take the time to do this for me

Rob

Thanks very much Steven I will try it

Hi Steven
Sorry to bother you
Remember my code knowledge is almost zero

It didn't work for me
Did I need to add anything at all to that code you supplied ?

Rob

Did it do anything?

maybe it is just erroring on one of the lines because it doesn't have a valid name.
try the below.

Otherwise you might want to click 'go advanced" and "manage attachments" and show us.

Please Login or Register  to view this content.

Thanks scottie and steven
Tried again and nothing happens
I run the macro but pictures do not appear
I did a really simple worksheet with only 6 image names in column B (B1 to B6)
Even moved the images (6 of them) to another location C:\testmacro
Altered the code to accommodate them two changes but still nothing
Made sure macros are enabled as well
I right click the tab and view code and this is where i paste the code then run macro
I must be doing something wrong

Thanks again to Steven and Scottie
4.00 am in bed this morning I realized again why I am a complete Turkey Novice at this code stuff.
Your brilliant codes work perfectly I just had to realize I needed to highlight the cells before running the macro (Goose)
So problem solved on excel forum once again