Microsoft KB Archive/119131

{|
 * width="100%"|

XL5: Data Type Example Does Not Work with Dynamic Array

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c

-

SYMPTOMS
When you run the example code on page 118 of the "Visual Basic User's Guide," included with Microsoft Excel version 5.0, you receive the following error message:

Run-time error '9':

Subscript out of range

The following code assumes that you are referring to the fixed-size array example:

  Dim MySystem As SystemInfo MySystem.DiskDrives(1)="1.44 MB" However, if you use this code with a dynamic array, you receive the error message above.

WORKAROUND
To work around this problem, add the Redim statement to the code in the example, as shown in the example below:

  Dim MySystem As SystemInfo Redim MySystem.DiskDrives(5) As String MySystem.DiskDrives(1)="1.44 MB"