If you are handling a huge dataset and your program is taking too much time to run, then you can use the following trick:
Application.Calculation = xlCalculationManual
' Put your code here
Application.Calculation = xlCalculationAutomatic
Refer the below URLs to know more about Excel's 'Calculation' property:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance
Happy Learning !!
MSExcel Excel VBA Microsoft
No comments:
Post a Comment