本帖最后由 h486 于 2014-3-29 23:13 编辑
我写的这段代码想用vba把需要数据粘贴到发放表内(按条件选择后顺序排列,并实现左右的粘贴),可是写的这段代码没办法从a3开始排序,请高手帮忙。
- 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
复制代码
|