|
本帖最后由 风林火山 于 2014-1-26 09:43 编辑
- Sub 提取回单号()
- Dim d As Object, arr, k%, i%
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("产品逐单列表").Range("h1:h" & Sheets("产品逐单列表").Cells(Rows.Count, 8).End(3).Row)
- For k = 2 To UBound(arr)
- If d.exists(arr(k, 1)) = False And Len(arr(k, 1)) > 1 Then d(arr(k, 1)) = ""
- Next k
- Sheets("效果").Columns("a:a").ClearContents
- Sheets("效果").Range("a1:a" & d.Count + 1).NumberFormatLocal = "@"
- Sheets("效果").Range("a1") = "回单号"
- Sheets("效果").Cells(2, 1).Resize(d.Count, 1) = Application.Transpose(d.keys)
- End Sub
复制代码 |
|