VBA Export Image with wrong column name

Gencod.PNG

Gencod.PNG

So I have 2 problems with my VBA :

1 : I need to export the each image of the A column with the name of the B column, but the problem is that the code will export the B2 name with the A3 images and so on.

So at the end the names will be like :
Image - Name/Reference
A3 - B2
A4 - B3
A5 - B4...

Second; The code will not save the images that are repeated.
Sometimes I have 2 references with a repeated image so it will save the first reference with that image but not the second.

Please Login or Register  to view this content.

Thanks for your help!

First start with removing On Error Resume Next in order to see where your logic fails ...

Thanks for the tip Marc!

Actually it keeps going like nothing,

I've changed this line from (B1,1) the code to :

xStrImgName = xImg.TopLeftCell.Offset(1, 1).Value

Now the problem is that it wont save all of the pictures and I'm not sure why.

I have 48 references but will only save 43. :/