VBA-要想宏跑的快,需要用到数组,原因是Excel的读写非常慢,需要将EXCEL文件先放入数组,然后数组一次性传给Excel,这样能够提升速度
Sub 统计()
Dim wb_yuanshi As Workbook
Dim sht_yuanshi As Worksheet
Dim wb_tongji As Workbook
Dim sht_tongji As Worksheet
Dim range_yuanshi As Range
Dim range_tongji As Range
Dim range_yuanshi_shuzu(