Insert multiple images into excel across two columns

Hi Everyone,

Hoping I can get some help please (basic vba knowledge here). I have a code that allows me to open a folder and download multiple images from a specified point (A7) into every second row (and autofit to the current row height). All of this works like a dream... except for the life of me I cannot work out how to load the images across columns A and B. For example I select 5 images from my folder which loads to cells A7, B7, A9, B9, A11 etc (or every second row from A7 and B7). Currently the images load at A7, A9, A11 etc.

I have played with selecting different ranges etc but I just don't have the experience to understand how to upload the images in both columns A and B into every second row? If anyone is able to assist that would be greatly appreciated. The code is below.

Thank you in advance

Please Login or Register  to view this content.

Hi Natstin,

I used a counter to determine when to go to the next column or the next row. The constant nITEMS_PER_ROW can be changed to determine how many items go on each row.

You were very close. Try the following:

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

Thank you so much Lewis, that works perfectly and I have updated my Tools/Options with Require Variable Declaration now as well.

I really appreciated your help with this, thank you