|
本帖最后由 无聊的疯子 于 2011-8-11 19:50 编辑
回复 cxh5237@163.com 的帖子
用下面的代码来替换你的函数公式
- Workbooks.Open ThisWorkbook.Path & "\副本2011生产进度明细表.xls", 0, Password:="333333"
- arr = Range("A5:W" & Range("A65536").End(xlUp).Row)
- ActiveWorkbook.Close False
- Workbooks("07-20.xls").Activate
- With Sheets("汇总表")
- row2 = Range("a65536").End(xlUp).Row
- ReDim arr1(row2, 1)
- For N = 2 To row2
- arr1(N - 2, 0) = Application.VLookup(.Cells(N, 1), arr, 22)
- arr1(N - 2, 1) = Application.VLookup(.Cells(N, 1), arr, 23)
- Next
- .Range("I2").Resize(UBound(arr1), 2) = arr1
- End With
复制代码
|
|