Excel gurus, Is there a precise formula to calculate the row height (in points or pixels) from the font size?
Here are my specifics: * Screen resolution is 96dpi * Default font is Verdana 8pt * Verdana font has an ascent of 1005 and a descent of -209 (total span is 1214; 1.214em?) With this information, I'd like to be able to calculate what the height of a row will be if I set the cells in that row to a specific font size. For example, if I set an entire row to Verdana 100pt, the row will automatically resize to allow for this font to adequately fit inside of the cells on this row. The height of the newly resized row is 121.5pt (162 pixels). My question is how can I go from the font size (100pt) to the final row height (121.5pt)? Here's a list of font sizes and the resulting row heights: 6pt becomes 8.25pt (11px) 8pt becomes 10.5pt (14px) 10pt becomes 12.75pt (17px) 12pt becomes 15pt (20px) 23pt becomes 30pt (40px) 24pt becomes 29.25pt (39px) 100pt becomes 121.5pt (162px) 200pt becomes 244.5pt (326px) A quick look at these conversions shows something is clearly non- linear (ie - 24pt font is actually smaller than 23pt font; 200pt is more than double 100pt; etc.) I've tried to model the relationship, but have not been able to do so. Here's one attempt I made: 10pt * (1.214em) * (1in / 72pt) * 96dpi = 16.187px -> rounds to 16px (12pt -- should be 12.75) 100pt * (1.214em) * (1in / 72pt) * 96dpi = 161.866px -> rounds to 162px (121.5pt -- correct!) 200pt * (1.214em) * (1in / 72pt) * 96dpi = 323.733px -> rounds to 324px (243pt -- should be 244.5!) Does anyone know how to accurately predict this? if so, what is the formula that will give the results I listed above? Thanks, Steve --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
