Well I figured out my problem. I figured I should put the solution here in case anyone else ever has this issue and searches for it...
I had hidden all cells outside of the formatted area of the output worksheets. When you hide the cells, even if the lockaspectratio is set to True, an image height or width will be shrunk to fit the space. Once the aspect ratio is distorted, there didn't seem to be a way change it back... So I unhide the extra empty cells. I also simplified my code to look like this:
Basically, I insert the picture full size to ensure the aspect ratio holds true. Then I check to see if the width or the height will fill the required range (basically to check portrait vs landscape). If the width will fill the range, I change the width to the max (577.5), then center the image vertically. If instead the height will fill the range, then I set the height to the max (345) then center the image horizontally.
Hope this helps.
Bookmarks