请帮忙解释下面语句意思-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
人气:443 ℃ 时间:2019-08-04 15:16:52
解答
Do While Cells(k,n).Text = ""
循环执行 条件是 如果表格 行K 列N 的内容是“”(空的) 就继续循环执行
推荐
猜你喜欢
- (12-x)/(18-x)=4/7这个方程怎么解
- 完形填空,敬请高人教导!谢谢
- 改成陈述句:父亲坚决地对母亲说:“我是不能轻易离开北京的.”
- 设变量x,y,a,b,c,d的值为1,计算表达式(x=a!=b)&&(y=c!=d)后,变量x,y的值分别是:
- 英语翻译
- 已知一个圆柱的底面半径为2.32cm,它的高为7.06cm,利用计算器求这个圆柱的体积.
- 有21 吨水泥,小卡车载重3吨运费150元,大卡车载重5吨运费200元,怎样能一次运完这些水泥,共需要花费多少钱
- 三角形ABC和三角形COD均为等腰三角形,角AOB=角COD=90度,D在AB上,求证三角形AOC全等于三角形BOD