|
[replyview]第十一集作业
'作业一:任选区域,大于0的填充为正确 a1-H26
Sub job2()
Dim x As Integer
Dim y As Integer
For x = 1 To 26
For y = 1 To 8
If Worksheets("练习11").Cells(x, y) > 0 Then
Worksheets("练习11").Cells(x, y) = "正确"
End If
Next
Next
End Sub
♥'作业二:一次选取a2:c12区域所有0数字所在的行 ♥
Sub job3()
Dim rg As Range
Dim x As Integer
Dim y As Integer
Dim n As Integer
n = 0
For x = 2 To 12
For y = 1 To 3
If Worksheets("练习11").Cells(x, y) = 0 Then
'初始化要命啊
n = n + 1
If n = 1 Then
Set rg = Worksheets("练习11").Cells(x, y)
ElseIf n > 1 Then
Set rg = Union(rg, Worksheets("练习11").Cells(x, y))
End If
End If
Next
Next
rg.EntireRow.Select
End Sub[replyview]
|
|