can I maintain aspect ratio when inserting pictures

[tryer]

I am using the code below to insert pictures in my spreadsheet. this code resizes the pictures slightly smaller than the target cell and positions it to line up with the top and left hand size. This works fine for pictures that have been taken in landscape mode (as the cells have been resized to accomodate this). However if a picture has been taken in Portrait (camera rotated by 90deg.) then the aspect ratio of the imported picture gets badly distorted as it it stretched widthways to fill the cell.
One way I think it could be done would be if the ratio of width to height could be checked at the point marked in the code below then two seperate resize/insert sections of code could be used. However I don't know how to check the size of the picture after it has been inserted or if ths is even possible.
Any thoughts?

Please Login or Register  to view this content.

[antoka05]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

[tryer]

That works a treat

Thank you