Excel will actually accept 409.5, but nothing bigger. It is kind of fun to play around with various fractional point sizes to see how Excel modifies them. a ridiculous number, an error message chides you by saying row height must be between 0 and 409. For instance, if you type 21.4, Excel increases the point size to 21.5.
(This depends, of course, on the capabilities of your printer.) You can use the keyboard to enter, in the Font Size tool, any point size (or fractional point size to the nearest half point) desired. Excel allows you to specify any font size between 1 and 409 points. You are not limited to choosing a point size from those in the list, however. Click your mouse on the point size, and your text is updated. To pick a point size, simply scroll through the list and choose the one you want. I would change the constant xlAutomatic to xlColorIndexAutomatic.
Hello bobaftt, Not sure how you concluded the ColorIndex was the problem since it does not affect the font size. If you click on the arrow to the right of this tool you are presented with a drop-down list of point sizes you can specify for the current font. Re: runtime error '1004' font size must be between 1 and 409 points. In the Font group you'll notice the Font Size tool. To change the size of a font used in a selected cell or for information selected within a cell, you use the Home tab of the ribbon. A point is equal to approximately 1/72 of an inch. Excel font size must be between 1 and 409. Excel specifies the size of fonts in points, a unit of measurement typically used in typesetting.
