|
本帖最后由 我不知道呀 于 2012-3-14 22:35 编辑
Sub 方法一()
Dim i As Integer
Dim str As String
Dim str1 As String
For i = 2 To Range("a65536").End(xlUp).Row
If Cells(i, 4).Value > 20 Then
str = str & "d" & i & ","
End If
Next
str1 = Left(str, Len(str) - 1)
Range(str1).EntireRow.Select
End Sub
Sub 方法一一()
Dim i As Integer
Dim str As String
Dim str1 As String
Dim rng As Range
For Each rng In Range("d2: d11")
If rng > 20 Then
str = str & rng.Address & ","
End If
Next
str1 = Left(str, Len(str) - 1)
Range(str1).EntireRow.Select
End Sub
-------------------------------------------------------
Sub 方法二()
Dim i As Integer
Dim rng As Object
For i = 2 To Range("a65536").End(xlUp).Row
If Cells(i, 4).Value > 20 Then
If rng Is Nothing Then
Set rng = Rows(i & ":" & i)
Else
Set rng = Union(rng, Rows(i & ":" & i))
End If
End If
Next
rng.Select
End Sub
-------------------------------------------------------
Sub 方法三()
Dim i As Integer
Dim rng As Range
For i = 2 To Range("a65536").End(xlUp).Row
If Cells(i, 4).Value > 20 Then
If rng Is Nothing Then
Set rng = Cells(i, 4)
Else
Set rng = Union(rng, Cells(i, 4))
End If
End If
Next i
rng.EntireRow.Select
End Sub
|
评分
-
查看全部评分
|