However, after compiling your code, the file size is likely to be much larger.


----- Chip Pearson wrote: -----

VBA code exists in two states: OpCodes which is how generic VBA is stored in
files, and ExCodes which are interpreted at run time. The Compile operation
converts OpCodes to ExCodes. From a user standpoint, it is most useful as a
syntax checker (e.g., looking for undeclared variables).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Juggernath" wrote in message
...
What is it really about, there isn't any compiled com?