In general, 'dynamic' means 'at run time' and 'static' means 'at
compile time'. For example, a dynamic array is sized at run time
depending on a variety of considerations, while a static array is
sized in the code. E.g.,
' dynamic array
Dim Arr() As Long
Redim Arr(1 To SomeRange.Cells.Count)
' static array
Dim Arr(1 To 10)
In the first example, the size of the array isn't determined
until the code executes. In the second example, the size of the
array is hard coded.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"mike" wrote in message
...
Forgive me , i see the word dynamic alot in programs and
code..can anyone tell what it means in terms of coding or
vba language? Such as 'I set it up to dynamically
load....'
thanks...