Difference between RowHeight and Height

[kobusb]

According to the help file reading .RowHeight and .Height for a single row range should give the same answer. This however does not happen as can be seen from the following:
<table width="211" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2304;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:2304;width:47pt" width="63"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:64pt" width="85" height="20"> .RowHeight </td> <td class="xl67" style="border-left:none;width:47pt" width="63"> .Height </td> <td class="xl68" style="border-left:none;width:47pt" width="63">Error</td> </tr> <tr style="mso-height-source:userset;height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;border-top:none" height="20"> 15.00 </td> <td class="xl69" style="border-top:none;border-left:none"> 15.00 </td> <td class="xl70" style="border-top:none;border-left:none"> - </td> </tr> <tr style="mso-height-source:userset;height:15.2pt" height="20"> <td class="xl69" style="height:15.2pt;border-top:none" height="20"> 15.25 </td> <td class="xl69" style="border-top:none;border-left:none"> 15.00 </td> <td class="xl70" style="border-top:none;border-left:none"> -0.25 </td> </tr> <tr style="mso-height-source:userset;height:15.6pt" height="20"> <td class="xl69" style="height:15.6pt;border-top:none" height="20"> 15.50 </td> <td class="xl69" style="border-top:none;border-left:none"> 15.00 </td> <td class="xl70" style="border-top:none;border-left:none"> -0.50 </td> </tr> <tr style="mso-height-source:userset;height:15.75pt" height="21"> <td class="xl69" style="height:15.75pt;border-top:none" height="21"> 15.75 </td> <td class="xl69" style="border-top:none;border-left:none"> 15.75 </td> <td class="xl70" style="border-top:none;border-left:none"> - </td> </tr> <tr style="mso-height-source:userset;height:15.95pt" height="21"> <td class="xl69" style="height:15.95pt;border-top:none" height="21"> 16.00 </td> <td class="xl69" style="border-top:none;border-left:none"> 15.75 </td> <td class="xl70" style="border-top:none;border-left:none"> -0.25 </td> </tr> <tr style="mso-height-source:userset;height:16.35pt" height="21"> <td class="xl69" style="height:16.35pt;border-top:none" height="21"> 16.25 </td> <td class="xl69" style="border-top:none;border-left:none"> 15.75 </td> <td class="xl70" style="border-top:none;border-left:none"> -0.50 </td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl69" style="height:16.5pt;border-top:none" height="22"> 16.50 </td> <td class="xl69" style="border-top:none;border-left:none"> 16.50 </td> <td class="xl70" style="border-top:none;border-left:none"> - </td> </tr> <tr style="mso-height-source:userset;height:16.7pt" height="22"> <td class="xl69" style="height:16.7pt;border-top:none" height="22"> 16.75 </td> <td class="xl69" style="border-top:none;border-left:none"> 16.50 </td> <td class="xl70" style="border-top:none;border-left:none"> -0.25 </td> </tr> <tr style="mso-height-source:userset;height:17.1pt" height="22"> <td class="xl69" style="height:17.1pt;border-top:none" height="22"> 17.00 </td> <td class="xl69" style="border-top:none;border-left:none"> 16.50 </td> <td class="xl70" style="border-top:none;border-left:none"> -0.50 </td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl69" style="height:17.25pt;border-top:none" height="23"> 17.25 </td> <td class="xl69" style="border-top:none;border-left:none"> 17.25 </td> <td class="xl70" style="border-top:none;border-left:none"> - </td> </tr> </tbody></table>
Note that RowHeight can only be set in steps of 0.25 points. It seems that Height is only reported in steps of 0.75 points.
I am using Excel 2010.

Is this a bug or am I missing something?

 

[GlennUK]

That does seem odd. Testing in Excel 2007 doesn't do that ... and I do not have access to Excel 2010 I'm afraid. Maybe someone else on here with 2010 can check ... anyone???