那么的帅 发表于 2013-6-22 12:13
老师您好,谢谢您帮助。下载试了一下。
数据文件夹下,五个工作薄 1 2 3 4 5,每个工作薄四列数据,每列1048575行。执行时,运行40秒后,出现错误提示:
For P = 1 To UBound(Arr0) For Q = 1 To UBound(Arr2) If Arr0(P, 1) = Arr2(Q, 1) And Arr0(P, 2) = Arr2(Q, 2) And Arr0(P, 3) = Arr2(Q, 3) Then M1 = M1 + 1 For J = 1 To 4 Arr11(M1, J) = Arr2(Q, J) Next J Arr11(M1, 5) = Q End If Next Q Next P Sheets.Add after:=Sheets(Sheets.Count) With Sheets(Sheets.Count)
不知何故?
谢谢老师。 |