Image disappears after insertion to excel.

[vodicto1]

Dears,

I would like to ask you for help. I have a macro for cropping, resizing and inserting image to the cell. Nevertheless, the images are somehow connected with the cells and when I want to send the sheet by email or move the images in my local, all added images are disappeared.

My macro is able to see below.

Please Login or Register  to view this content.

Thank you for support.

[KOKOSEK]

Instead of picture insert use add:

Please Login or Register  to view this content.

This part:

Please Login or Register  to view this content.

not tested but should works.

p.s. could you edit your post and wrap vba code into CODE (# icon) tag, please?

[vodicto1]

Dear KOKOSEK,

Code is not working properly. When I run the script I am able to choose the image what I want to add, however, error occur due to line

Please Login or Register  to view this content.

Object does not support this property or method.

If the PrintObject is deleted, image is not added anyway, nevertheless, the script works without any error.

Could you double check it, please?

Thank you very much for strong support.

Regards

[KOKOSEK]

This definitely insert picture. I've add some lines from your code, please add the rest (crop section):

Please Login or Register  to view this content.

[vodicto1]

Dear KOKOSEK,

It works properly. Thank you very much! I appreciate. You can close this topic.

For future tracking of similar issue I am adding full working script for image cropping, resizing and inserting to the specify cell.

Please Login or Register  to view this content.

Best Regards

[KOKOSEK]

Happy to help.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.