|
- Sub test()
- Dim rng As Range
- arr = Sheets("sheet1").[a1].CurrentRegion.Value
- For i = 1 To UBound(arr)
- For j = 2 To 8 Step 2
- If arr(i, j) = 100 Then
- If rng Is Nothing Then Set rng = Cells(i, j - 1).Resize(, 2) _
- Else Set rng = Union(rng, Cells(i, j - 1).Resize(, 2))
- End If
- Next
- Next
- rng.Select
- End Sub
复制代码 |
评分
-
查看全部评分
|