Excel Err Msg: "Size Must Be Between 1 And 409 Points"

Last reviewed: November 29, 1994
Article ID: Q85435

The information in this article applies to:

Microsoft Excel for Windows, version 4.0

SYMPTOMS

In Microsoft Excel for Windows, version 4.0, attempting to enter a non-integer font size, for example 8.5, in the Format Font dialog box will result in the error, "Size Must Be Between 1 and 409 Points."

STATUS

Excel for Windows version 5.0 does not use the COMMDLG.DLL to derive available font point sizes. This problem does not occur in version 3.0, which also did not use COMMDLG.DLL.

CAUSE

Excel 4.0 derives the available font point sizes from the Windows COMMDLG.DLL. This .DLL does not support non-integer font point sizes. A similar error will occur with any application that utilizes COMMDLG.DLL, for example, Microsoft Write running with Windows 3.1.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, page 217

KBCategory: kberrmsg
KBSubcategory:
Additional reference words: 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.