Learn VBA Part 27 -Speed Up Loop in VBA Hindi
The loops in vba excel can be speed up to run faster and have lower impact on memory. To speed up loop in vba excel we need to stop excel fro auto calculating sheet and stop excel from updating the screen .
In the Learn VBA series I have used 2 options to speed up code in VBA
1. Application.calculation
2. Application.update