Need VBA to insert pic based on cell value from a path specified

[sryadav12]

Hello Morning Everyone,

Thanks for the help in advance, I need a VBA to insert an image in B1, B2.. based on cell values mentioned in cell A1, A2... I have my all images in a specific folder.

Please help me as I have to insert around 500 images also make sure If I send excel file to anyone the images should not get disappear from excel.


NOTE: EXCEL FILE ATTACHED FOR THE REFERENCE.

[Marc L]

Hi !

As we can't fill 'holes' a good starter is to activate the Macro Recorder and operate manually in order to get a code base …