Dynamic Arrays : Dynamic Array « Date Functions « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » Date Functions » Dynamic Array 
Dynamic Arrays
 
Sub arrayTest1()
     Dim i As Integer
     Dim intMyScores() As Integer
     Dim intArraySize As Integer
     intArraySize = 10
    
     ReDim intMyScores(intArraySize)
    
     For i = 1 To intArraySize
        intMyScores(i) = i
     Next
    
     For i = 0 To intArraySize
        Debug.Print "For array element " & i & " the number is " & intMyScores(i)
    Next
End Sub

 
Related examples in the same category
1.Declaring and Working with Dynamic Arrays
2.Use ReDim to create dynamic array
3.Using a Dynamic Array
4.There's a potential problem when you try to resize the array:
5.A destroying the old values by using the Preserve keyword
6.Use the Preserve keyword to keep the values
7.Transpose() sub procedure is using a dynamic array that is re-dimensioned with two dimensions.
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.