我刚开始学习VBA编程,遇到了一个问题,但不知道如何解决。我认为一切都正常。但是当我想运行这个宏时,出现了“运行时错误'6'溢出”的提示。
Sub Działaj()
Dim Tablica(1 To 5000) As String
Dim Dni()
Dim kolumna As Integer
Dim wiersz As Integer
Dim licznik As Integer
Dim PF As Boolean
Dim tmp As Integer
Dim i As Integer
Dim tmp2 As String
licznik = 2
tmp = 0
PF = False
kolumna = 22
wiersz = 2
Do
If Worksheets("Początkowe").Cells(wiersz, kolumna).Value <> vbNullString Then
For i = 1 To licznik
If Worksheets("Początkowe").Cells(wiersz, kolumna).Value = Tablica(i) Then 'debugger shows problem here i guess
PF = True
tmp = i
End If
Next i
End If
If Worksheets("Początkowe").Cells(wiersz, kolumna).Value = "koniec" Then
Exit Do
End If
wiersz = wiersz + 1
Loop
End Sub
有人能告诉我错在哪里吗?非常感谢。
If Worksheets("Początkowe").Cells(wiersz, kolumna).Value = Tablica(i)
,但在该行代码之前的任何时候,你都没有为数组分配一个值,因此此时的Tablica(i)是一个空字符串。 - nutsch