View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robotman@gmail.com is offline
external usenet poster
 
Posts: 73
Default What does # mean in front of IF statements

I didn't realize that VBA compiles on-the-fly before it runs. In VB,
you have to specifically compile the code. Thanks for the explanation.
That is handy for cross-platform application.

So are the "win32" and "mac" just system variables that each OS sets in
the VBA code?

And now a new problem... my conditional statements are just being
ignored. They were working fine, but now when it gets to the #IF, it
just skips to the next section of code and doesn't even check the
condition. It appears to only be a problem on the one computer I
program on.

Any ideas what happened?