请帮忙解释下面语句意思-2'填写遗漏值 Dim n As Integer Dim arrR() As Integer, arrB() As Integer ReDim arrR(5), arrB(5) Dim r As Range Dim k As Long Dim t As Integer arrR(0)
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/18 03:59:54
![请帮忙解释下面语句意思-2'填写遗漏值 Dim n As Integer Dim arrR() As Integer, arrB() As Integer ReDim arrR(5), arrB(5) Dim r As Range Dim k As Long Dim t As Integer arrR(0)](/uploads/image/z/5042322-18-2.jpg?t=%E8%AF%B7%E5%B8%AE%E5%BF%99%E8%A7%A3%E9%87%8A%E4%B8%8B%E9%9D%A2%E8%AF%AD%E5%8F%A5%E6%84%8F%E6%80%9D-2%27%E5%A1%AB%E5%86%99%E9%81%97%E6%BC%8F%E5%80%BC++++++++++Dim+n+As+Integer++++++++++Dim+arrR%28%29+As+Integer%2C+arrB%28%29+As+Integer++++++++++ReDim+arrR%285%29%2C+arrB%285%29++++++++++Dim+r+As+Range++++++++++Dim+k+As+Long++++++++++Dim+t+As+Integer++++++++++arrR%280%29)
请帮忙解释下面语句意思-2'填写遗漏值 Dim n As Integer Dim arrR() As Integer, arrB() As Integer ReDim arrR(5), arrB(5) Dim r As Range Dim k As Long Dim t As Integer arrR(0)
请帮忙解释下面语句意思-2
'填写遗漏值
Dim n As Integer
Dim arrR() As Integer, arrB() As Integer
ReDim arrR(5), arrB(5)
Dim r As Range
Dim k As Long
Dim t As Integer
arrR(0) = 9
arrB(0) = 9
Range("B3:AX7").Value = ""
For n = 2 To 50
k = 9
Do While Cells(k, n).Text = ""
k = k + 1
Loop
For t = 1 To 5
Do While Cells(k, n).Text = ""
k = k + 1
Loop
arrR(t) = k
arrB(t) = k
k = k + 1
If n < 35 Then
If Cells(k, n).End(xlDown).Row > 65530 Then Exit For
Cells(t + 2, n) = arrR(t) - arrR(t - 1) - 1
ElseIf n > 34 Then
If Cells(k, n).End(xlDown).Cells.Row > 65530 Then Exit For
Cells(t + 2, n) = arrB(t) - arrB(t - 1) - 1
End If
Next t
Next n
Exit Sub
End If ' If Target.Value = Sheets("双色球").Cells(i, 2)
Next i
Else 'If Len(Target.Value) = 7
Exit Sub
End If 'If Len(Target.Value) = 7
End Sub
请帮忙解释下面语句意思-2'填写遗漏值 Dim n As Integer Dim arrR() As Integer, arrB() As Integer ReDim arrR(5), arrB(5) Dim r As Range Dim k As Long Dim t As Integer arrR(0)
Do While Cells(k,n).Text = ""
循环执行 条件是 如果表格 行K 列N 的内容是“”(空的) 就继续循环执行