Picture Insert Macro Question

[audette89]

I'm trying to come up with a macro that opens up the file explorer and then allows you to select a bunch of pictures and insert them into a sheet. The only thing is I'm trying to insert them in a specific format like below:

I have the pictures in order in a folder and I want to paste them into 1 then 2 then 3 then 4 repeating all the way down the sheet, but with the alternate row in between empty.

Does anyone know how to code this one?

Thank you in advance.

 

[NdNoviceHlp]

Hi *audette89 and Welcome to the Board! It seems like the code at this link will do it. HTH, Dave

To import all picture from folder and sort into specific cell

Hello i have dynamic number of picture in folder namely path "C:\Users\User\Pictures\" but not exceeding 30 pictures i want to create macro to import all picture from this folder into below specific cell in "Sheet1"...

www.mrexcel.com