Avoid Using Variants

Variants take more memory and it’s slower to get/set their values thanother data types. Option 1 will run slower than Option 2. Option 1:

 Dim iLoop As Variant For iLoop = 1 To 100 Print iLoop Next ,

Option 2:

 Dim iLoop As Integer For iLoop = 1 To 100 Print iLoop Next 
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: