I'm new at VBA. I essentially want to start the macro, select a photo, have it rotate if needed and center it in the selected cells while keep aspect ratio. Then have it embedded within the document.
So far, I can embed the photo to where it actually stays with the document through email, etc. but it distorts the photo and won't rotate it (ever). I've had many people try to help but we can't seem to get it trying different methods.


Pics are always the same size but sometimes the camera is turned 90 degrees.
for example.
The photo will either be:
1) H=3456 pixels W=4608 pixels
OR
2) H=4608 pixels W=3456 pixels


I always want the photo rotated to the first option essentially just rotating it 90 if needed.


Can someone please help?

Attached Images

picture test1.jpg (89.4 KB, 17 views)