|
本帖最后由 wangchangjun 于 2012-3-20 20:05 编辑
我依葫芦画瓢用一种方法做,没有交作业。
Sub xuanqu2()
Dim x, y, z, hang
For x = 2 To 11
If Cells(x, 4).Value > 20 Then
y = Cells(x, 4).Row & ":" & Cells(x, 4).Row
z = z & "," & y
End If
Next
hang = Right(z, Len(z) - 1)
Range(hang).EntireRow.Select
End Sub
在网上搜到另一种做法。
Sub xuanqu1()
Dim x As Integer
Dim rg As Range
Dim y As Integer
For x = 2 To 11
If Cells(x, 4) > 20 Then
y = y + 1
If y = 1 Then
Set rg = Cells(x, 4)
Else
Set rg = Union(rg, Cells(x, 4))
End If
End If
Next
rg.EntireRow.Select
Set rg = Nothing
End Sub
|
|