MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Very Basic Question


Posted by doug on February 28, 2001 12:51 PM

Does Diming a variable before using it make it any faster for the program to access it?


Posted by David Hawley on February 28, 2001 1:16 PM


Hi Doug

The answer is yes. But unless you have a large project the speed difference will not be noticeable. If you do not Dim variables all are treated as variants, which means Excel has to set aside more bytes than it would if it were dimensioned.

OzGrid Business Applications