|
小白求助,excel运行宏时就卡死,退出时提示:”方法value作用于对象range时失效,请问是什么原因呢?是电脑配置太低造成的吗?宏:已知a,b两列数据,合并a列相同数据,与之对应的b列数据合并用逗号隔开保存.目前a,b两列各有2万+数据,一跑就卡死。。。
宏代码
Sub g()
Dim rng As Range
Set d = CreateObject("scripting.dictionary")
For Each rng In Range(Cells(2, 1), Cells(Rows.Count, 1).End(3))
d(rng.Value) = ""
Next rng
For Each rngd In d.keys
For Each rng In Range(Cells(2, 1), Cells(Rows.Count, 1).End(3))
If rngd = rng.Value Then
t = t & rng.Offset(, 1) & ","
End If
Next rng
n = n + 1
Cells(n + 1, "d").Value = rngd
Cells(n + 1, "e").Value = Left(t, Len(t) - 1)
t = ""
Next rngd
End Sub |
|
|