- 帖子
- 1572
- 主題
- 16
- 精華
- 2
- 積分
- 1521
- 點名
- 0
- 作業系統
- xp
- 軟體版本
- office 2003
- 閱讀權限
- 150
- 性別
- 男
- 註冊時間
- 2010-5-1
- 最後登錄
- 2016-1-13

|
2#
發表於 2011-2-6 20:47
| 只看該作者
改這樣會快得多
Sub pp()
Dim mSht As Worksheet
Dim d As Object, arr
Dim s%, m%, r%
Dim mRng
Set d = CreateObject("Scripting.Dictionary")
Set mSht = Worksheets("Test")
With mSht
mRng = .Range("a1:g10988")
r = UBound(mRng, 1)
For s = 1 To r
arr = Array(mRng(s, 1), mRng(s, 2), mRng(s, 3), mRng(s, 4), mRng(s, 5), mRng(s, 6), mRng(s, 7))
MyCom = Join(arr)
d(s) = MyCom
Next
.Range("h1").Resize(r) = Application.Transpose(d.items)
.Range("h1") = "合併簽審"
End With
End Sub |
|