程序这么写慢死了,要循环多少次啊,你的意思是在两张表里找相同的部分,复制到一个表的空白处吧,这么写:Sub 找相同() Dim arr, x As Long, y As Long, d As Object, crr(), o As Long Dim brr o = 1 Set d = CreateObject("scripting.dictionary") x = Sheets("公司现行基药").Cells(6500, 1).End(xlUp).Row Sheets("公司现行基药").Cells(1, 22) = "共有" & x & "条数据"y = Sheets("平台基药库存").Cells(6500, 1...
|