Add_Pic Marco: Pictures zoom-in at random after re-opening?!

Dear all,

I am new at Marcos. I have to insert a lot of pictures into various Excel worksheet. The Macro is created by someone else.
Every time I open the file, some pictures are zoomed-in or completely blurred at random. The one time it concerns picture X, the other time it is picture Y.
Most of the times I use the "Insert Picture Here" button, which was especially created to avoid formatting errors. However, there were some occasions where I used "Insert > Image" from the Excel Menu.

Here is the Add_Pic Macro code:

Please Login or Register  to view this content.

[/COLOR][/COLOR][/COLOR]

The Excel file is basically a template for setting up Work Instructions for our production facility. Therefore, the pictures have an important function as they visualize the various steps in the Work Instructions. The problem thus needs to be fixed otherwise the files are of no use due to reliability issues. Here is a screenshot of a part of the worksheet. The second image is zoomed in, only a detail is visible.
Worksheet.jpg

Could there be something wrong with the Macro code?

Thanks a lot for your help.
Kind regards,

Eline de Vrij

Hi edv,

Just in perusal, I noticed that you have top and left dimensioned as Long, you should change that to Single. I may give your issue more regard anon

Hi edv,

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic