|
发表于 2014-3-30 09:22
|
显示全部楼层
本楼为最佳答案
- Sub test()
- On Error Resume Next
- Dim rng As Range, arr, i&, s&, x&, d
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet2.Range("a1").CurrentRegion
- Sheet1.Activate
- Set rng = Union([a3:a32], [e3:e32])
- rng.ClearContents
- For Each cel In rng
- x = x + 1
- d(x) = cel.Address
- Next
- For i = 2 To UBound(arr)
- If arr(i, 1) = "b部门" Or arr(i, 1) = "c部门" Then
- s = s + 1
- Range(d(s)).Resize(1, 3) = Application.Index(arr, i, 0)
- End If
- Next
- End Sub
复制代码 |
|