Making Faster For...Next Loops
Integers use less memory than the Variant data type and are slightly faster to update. However, this difference is only noticeable if you perform many thousands of operations. For example:
|
The first case above takes slightly less time to run than the second case. However, if
|
exceeds 32,767, an error occurs. To fix this, you can change
|
to the Long data type, which accepts a wider range of integers. In general, the smaller the data type, the less time it takes to update. Variants are slightly slower than their equivalent data type.