Private Sub Command1_Click()
Dim a() As String, i As Integer'------->改为LONG就不会溢出了
ReDim a(1000000)
For i = 0 To 1000000 Step 10000
a(i) = i
Debug.Print "a(" & i & ")=" & a(i)
Next
End Sub
Private Sub Command1_Click()
Dim a() As String, i As Integer'------->改为LONG就不会溢出了
ReDim a(1000000)
For i = 0 To 1000000 Step 10000
a(i) = i
Debug.Print "a(" & i & ")=" & a(i)
Next
End Sub
Private Sub Command1_Click()
Dim a() As String
ReDim a(1000000)
For i = 0 To 1000000 Step 10000
a(i) = i
Debug.Print "a(" & i & ")=" & a(i)
Next
End Sub