ahhhhh, yes. I understand now. makes sense. thank yu for
yur help. I like the dynamic. as for large files and many
variables. mike
-----Original Message-----
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...


.