• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA - reduce width of multiple images at once, with conditions


Active Member
I have found several VBA macros that resize multiple images. But it's not what I'm looking for.
It is necessary to select all images on Worksheet and to reduce with scale their size but under certain conditions.

The criterion is following.
1) If the image width is greater than 7.89 cm, it is necessary to reduce the image width to 7.89 cm
2) If the image is smaller than 7,89 cm, then it should remain the same width (It is not necessary to change the width)
3) Reduced pictures should keep proportional scaling.

Please see attached example. Thanks advance.



Active Member
:) :)
These are just examples. That's what I'm looking for.
Thank you very much.
With respect