|
本帖最后由 YZC51 于 2020-3-13 17:56 编辑
试试
Sub aa()
Dim wt, rng As Range, qc As Range, wc As Range
Range("j2:j30").NumberFormatLocal = "0_);[红色](0)"
Range("j2:j30") = Range("j2:j30").Value
wt = Application.Max(Range("j2:j30"))
For i = 2 To 30
If Int(Range("j" & i)) = Int(wt) Then
If rng Is Nothing Then
Set rng = Range("j" & i)
Else
Set rng = Union(rng, Range("j" & i))
rng.Select
a = Selection.Rows(1).Row()
b = Selection.End(xlDown).Row()
Range(Cells(a, 1), Cells(b, 11)).Select
End If
End If
Next
End Sub |
评分
-
2
查看全部评分
-
|