Why it is important to define variables with Dim in Excel VBA

Описание к видео Why it is important to define variables with Dim in Excel VBA

It is important to define the data types of the variables used in the VBA code because the speed of execution of the macro becomes much faster especially if you have many variables and need to perform thousands of calculations.
Our simple example demonstrates how the speed of the macro with defined variables is almost three times better than a macro without defining the data types for the variables using the 'Dim' keyword.
Details available at this web link:
http://www.exceltrainingvideos.com/wh...

Комментарии

Информация по комментариям в разработке

Похожие видео