So should you compile after every change you make to check it's not incorrect
anywhere?

"Bernie Deitrick" wrote:

Compiling the project checks that the syntax is correct and that the
variables are correctly typed in (that is, if you used Option Explicit,
which you always should.) Sort of checking for errors prior to running the
macro.

HTH,
Bernie
MS Excel MVP

"cdb" wrote in message
...
In the Debug option of the VBA window there's an option to compile the
project. What exactly does this do and what's the point in it?