ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro run much slower under VBA than in Excel (https://www.excelbanter.com/excel-programming/272720-macro-run-much-slower-under-vba-than-excel.html)

Bin

Macro run much slower under VBA than in Excel
 
I have a macro that process a data sheet with more than
10000 rows data, create 6 new sheets and copy some data
from the data sheet to them respectively.
When the macro run in Excel, it will take less than 5
Secons. But when run it under a external VBA program, it
will take more than 100 seconds. I have set screenupdating
= false at begining and turn it on at the end, but no any
improvement. Anybody can figure what is the problem and
how to fix? or just improve?
Thanks.


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com