Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need macro to start at a new line MHenderson Excel Worksheet Functions 2 November 2nd 07 04:00 PM
code to go to start of line BorisS Excel Programming 1 September 18th 06 07:27 AM
How do you start a new line within a cell? [email protected] New Users to Excel 4 August 12th 05 02:39 PM
when displaying formulas, how to start a new line in the same cel. EL Excel Discussion (Misc queries) 1 December 7th 04 07:18 AM
How to start this Line List No Name Excel Programming 0 May 18th 04 07:21 PM


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"