View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kevin.bourque@gmail.com is offline
external usenet poster
 
Posts: 5
Default Hash (#) at start of line in VBA

Makes perfect sense. Thanks for the link and the help.

Cheers,
Kevin

On Dec 28, 11:18 am, Jim Thomlinson
wrote:
The # symbol is a conditional compiler directive. Depending on your system
components, sofware versions or operating system the program will compile
diffrently. Check out this link...

http://msdn2.microsoft.com/en-us/lib...bk(VS.80).aspx
--
HTH...

Jim Thomlinson

" wrote:
I've come across several instances of code in which some statements
start with a hash mark/symbol (#). When stepping through the code,
these statements are skipped, as if they were comments.


For example, a line which has:


#Const SkipMe = True


is skipped. So would be:


#If whatever = 1 then
... 'anything in here would be skipped too
#End If


I have searched high and low, but can't figure out what these hash
marks (#) mean.


Any hints or pointers in the right direction?


Many thanks.