Do While Cells(k,n).Text = ""
循環(huán)執(zhí)行 條件是 如果表格 行K 列N 的內(nèi)容是“”(空的) 就繼續(xù)循環(huán)執(zhí)行
請幫忙解釋下面語句意思-2
請幫忙解釋下面語句意思-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
'填寫遺漏值
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
其他人氣:257 ℃時間:2019-08-04 15:16:52
優(yōu)質(zhì)解答
我來回答
類似推薦
猜你喜歡
- 1七年級下學(xué)期數(shù)學(xué)題(不等式與不等式組)
- 2At around twelve o'clock.翻譯
- 3The people of Norway are called Norwegians.
- 4震耳欲聾的近義詞和反義詞是什么?
- 5放棄造句
- 6陸生高等動物具有( )和防止水分散失的( ),是它們對陸地環(huán)境的一種重要適應(yīng)方式.
- 7英語翻譯
- 8在三角形ABC中,BC=a,AC=b,且a、b是方程x^2-(2根號3)x+2的兩個根,且2cos(A+B)=1,求AB的長度
- 9水結(jié)成冰后體積增加了111,冰融化成水后,體積減少( ?。?A.111 B.112 C.211 D.322
- 10best wishes for you everyday是什么意思
- 11從宏觀與微觀的角度描述水的變換過程
- 12食鹽(氯化鈉)的密度是多少?