Quote Originally Posted by Nouyana View Post
The same with RowHeightMax, RowHeightMin and ColWidthMax

Code:
With VBFlexGrid1
   .RowHeightMax = 500
   .RowHeight(1) = 600
   Debug.Print .RowHeight(1) ' The result is 495, not 500
End With
Code:
With VBFlexGrid1
   .RowHeightMin = 500
   .RowHeight(1) = 10
   Debug.Print .RowHeight(1) ' The result is 495, not 500
End With
Code:
With VBFlexGrid1
   .ColWidthMax = 500
   .ColWidth(1) = 600
   Debug.Print .ColWidth(1) ' The result is 495, not 500
End With
I guess the unit is twips. The unit for the given properties is pixel. A pixel is 15 twips. So if you set the property to a value other than a multiple of 15 (ratio twips/pixel) the property returns the next integer in twips. You set a height to 500 twips, that results in 33 pixel, that results in 495 twips.
greetings seniorchef