请帮忙解释下面语句意思-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
人气:211 ℃ 时间:2019-08-04 15:16:52
解答
Do While Cells(k,n).Text = ""
循环执行 条件是 如果表格 行K 列N 的内容是“”(空的) 就继续循环执行
推荐
猜你喜欢
- 已知关于x的方程x²—5x+p²—2p+5=0的一个根是1,求实数p
- 问个公式不是很明白请大家多指教 n=N/NA,物质的量.阿伏加德...
- 明明做两为数乘两位数乘法时,把因数22个位上的2看成了5,乘得的结果比实际结果多75,正确的结果应该是多
- 实数x、y满足4/x四次方-2/x²=3,y四次方+y²=3,求4/x四次方+y四次方的值
- 商店出售茶壶每只定价20元,茶杯每只定价5元,该店制定了两种优惠办法:(1)买一只茶壶赠送一只茶杯;(2)按总价的92%付款.某顾客需购茶壶4只,茶杯x只(x≥4),付款数为y(元),
- 母亲唱累了就给我讲嫦娥奔月的故事……高深莫测的夜空竟是个神话的世界.这句话在全文起()的作用
- There is some milk in the glass.改成否定句.
- 若三角形ABC全等于三角形DEF,三角形ABC周长为70cm,DE等于30cm,DF等于25cm,角B等于