XL: GetCustomListNum Returns Unexpected List Number

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

The GetCustomListNum method returns a number that is one less than the expected number when you use it to evaluate an array containing a custom list. When you use the number returned by the GetCustomListNum method as the OrderCustom argument for the Sort method, Microsoft Excel will still sort values using the default sort order and not the custom sort order as expected.

WORKAROUND

To work around this problem, add one to the number returned by the GetCustomListNum method for use within a procedure, as in the following example:

   Application.GetCustomListNum + 1

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

"Excel Visual Basic for Applications Reference," version 5.0, page 289, by Microsoft Press

For more information about GetCustomListNum, choose Help, Contents, Programming in Visual Basic, click the Search button and type:

   GetCustomListNum