Macro for inserting an image from a sheet/book into another sheet

**kukulkan** · 06-15-2022, 07:12 AM

Hi!

Please, can you help me to correct the macro, I don't really understand it.
The whole point is to transfer a photo from another book/sheet to the activesheet. I have a Sheet 1 in which there is a catalog with photos, and on Sheet 2 I need to transfer these photos according to the article. But something is clearly not done right

Thank you very much!

HTML Code:

**cytop** · 06-15-2022, 07:20 AM

From reading the code - you have a line

Please Login or Register  to view this content.

But iLastrow, while initialised, is never set to the number of rows so has a value of 0. The code never enters the 'For' loop.

Comment after reading code only, not tested so there may be other issues - in particular you cannot copy an image simply by copying the cell/range. Images 'float' over the worksheet and are not 'contained' in a cell. However, they do have a 'TopLeftCell' property so you'll probably need to find the image with a matching Top left cell address.