XL5: Data Type Example Does Not Work with Dynamic Array

ID: Q119131

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"

REFERENCES

"Visual Basic User's Guide," version 5.0, page 118

Additional query words:

Keywords : kbcode kbdocerr
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type :