VBA - Copy linked images in column A to embedded individual pictures in column N

[treazon]

Hi All

I have found a macro that imports images to Excel based on the filename of pictures in a folder on my computer. This works well so I'm not looking to change this macro.

I can then select each image in column A and copy and paste it as a picture into column N, which then embeds it into the document and enables me to send the document via e-mail including the pictures. However, this is very time consuming so it'd be great if someone could come up with a VBA code to do this automatically!

So to summarise:

1) Copy cell A2
2) Paste special -> paste as picture into cell N2
3) Copy cell A3
4) Paste special -> paste as picture into cell N3
5) Repeat for the remainder of column A until it reaches a blank cell

Thanks in advance!

Ben

 

[treazon]

I forgot to mention that I have pretty much zero VBA knowledge... I intend to learn soon but in the meantime please help me. I've got to get this finished by tomorrow and this will help massively. Hopefully it shouldn't be too difficult!

 

[treazon]