|
Sub sdfsdf()
Dim a(1 To 10000)
aaa = 1
Aff = Sheets("监基压").Range("A1:n" & Sheets("监基压").Range("A65536").End(3).Row)
For i = 25 To UBound(Aff) Step 25
If Sheets("监基压").Cells(i + 4, 10) = Sheets("监基压").Cells(i - 25 + 4, 10) And Sheets("监基压").Cells(i + 4, 12) = Sheets("监基压").Cells(i - 25 + 4, 12) Then
a(aaa) = i
aaa = aaa + 1
End If
Next上面不用看
For i = 1 To aaa
Sheets("监基压").Rows(a(i)).Select
怎么把a(i)数组里所有行号同时选择上?
Next
End Sub
- Sub test()
- Dim rng As Range
- arr = Array(1, 3, 5, 7, 9, 25, 99)
- For i = 1 To UBound(arr)
- If Not rng Is Nothing Then
- Set rng = Union(rng, Rows(arr(i)))
- Else
- Set rng = Rows(arr(i))
- End If
- Next
- rng.Select
- End Sub
复制代码瞎写的示例,可能不是你想要的,感觉你想得好高端
|
|