I have a workbook set to print a photo report (sample attached). Photos Sample.xlsx
  • A VBA code inserts the images into the worksheet and re-sizes them to a height of 8.47cms, and centered across the merged cells of the image row.
  • The images may be of Landscape or Portrait orientation. Set to a height of 8.47 cms, both types perfectly align to the row height (320 pixels) irrespective of the their width. (The width is kept proportional to the height, so the images maintain their 'aspect ratio').
  • The other row height are also predefined, such that 10 rows print per A4 page. (i.e. 2 photos to a page).
  • Lastly, I need the images to be of 8.47cms height, irrespective of the pixel units, or any other units.
All works fine on my display. However, when my colleague runs this on his PC, the images are not exactly aligned.

I'm guessing this has something to do with pixels vs cms. Is someone able to point me to some good articles on the subject of how images are sized in excel so I may learn from it.

The idea is to ensure that my images are always:
  • Sized to a height of 8.47cms. The width would adjust to whatever cms by maintaining the 'aspect ratio'.
  • Fit the row height, or rather that the row height should fit the image of height 8.47cms
  • Should happen across different size monitor displays. So that the report workbook can be freely shared/printed etc.. as desired.

Thanks in advance.