Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hash (#) at start of line in VBA
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to start at a new line | Excel Worksheet Functions | |||
code to go to start of line | Excel Programming | |||
How do you start a new line within a cell? | New Users to Excel | |||
when displaying formulas, how to start a new line in the same cel. | Excel Discussion (Misc queries) | |||
How to start this Line List | Excel Programming |