且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Excel VBA插入空白行花费的时间太长

更新时间:2023-11-04 14:25:22

通常来说,在Excel中插入很多行是PITA性能的明智之举.
您应该考虑在列表末尾添加行,并在流程结束时对整个列表进行排序.
我知道这是一个简短的答案,但这就是我现在可以从Chromebook所能完成的全部工作...

Generally speaking inserting a lot of rows in Excel is a PITA performance wise.
You should consider adding rows at the end of your list and sorting the whole list at the end of the process.
I know it's a bit short answer but it's all I can do from my Chromebook now...