Using Constants

Using constants in an application makes the application run faster. Constants are evaluated once and are stored when your code is compiled. Variables can change, though, so Visual Basic must get the current variable value each time the macro runs. Constants also make your macros more readable and easier to maintain. If there are strings or numbers in a macro that don't change, declare them as constants. For more information about creating constants, see "Constants" in Chapter 2.