That is the most coprehensive explanation that I have seen on how VBA works.
Thanks Jim.


"Jim Thomlinson" wrote in message
...
In the grander scheme of things not much from an execution stand point.
Where
it is useful is that it checks your code to confirm that there are no
syntax
errors. Code that has systax errors will execute up to the procedure with
the
error and then it will crash. To that end it is worth compiling. Here is
an
explanation of compiling in VBA...

http://orlando.mvps.org/VBADecompile...IdC=OrlMoreWin
--
HTH...

Jim Thomlinson


"CB" wrote:

Hello,
I notice in Excel VBA under the Menu "Debug" you see Compile VBAProject.
What does this do?
Kind Regards,
Charlie.B
.