Maintain image size across different size displays

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.

See if using something like this to set the rowheight helps

Please Login or Register  to view this content.

Mate,
Thanks for finding time to help me. Your suggestion may work, but it would be very laborious (a typical photo report in my case has 100+ images). So, I'm definitely looking for a VBA based approach. (Apologies, I should have mentioned this earlier).

Is there a VBA way to insert and position an image at a specified location of the page without referencing it to any row/column of the worksheet? (any code snippet that one could tweak). As I'd be printing this to A4, I know exactly where i want the image to be displayed (as in distance from the top and left of the page), and that position will not change between pages. I need the image to center to the page and be exactly of size 8.47 cms in height, whilst maintaining the aspect ratio, so the width may change.

Also, I do need to use Excel for this, as there are many other worksheets in this report (which I have not shared) that have several calculations and inter-links.

Mate,
Thanks for your suggestion. Prima facie, this should work. Will give it a crack and revert.

However, I also want to understand how the row heights and column widths are assigned in Excel; and why would that change from one system to another. Are there application level or workbook level settings that affect these values? I'd like to learn this.

Row height is based on font size, so will vary with the resolution and size of the display.

Change the font size of any cell (or range of cells) and the row height will automatically adjust to fit. Changing the height of any row (manually or with vba) will prevent this from happening unless autofit is subsequently applied to the row to 'reset' it.

This doesn't affect column width which would imply that there is a different default parameter there, maybe based on the default font set at application level when the workbook was created.