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"
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 :
Technology :
Last Reviewed: November 3, 1999 |