No, I'm referring to the line that show between subs when in design view. When I print the code, the lines do not appear. The lines between code help visually.
If there is, I don't know it. I just get in the habit of adding
'**********************************************************
at the top and bottom of the function. I think there are also some third party tools that will do it for you automatically.
For what it's worth, what I do is turn off the Procedure separator option, and add in the my own separator lines into the code.
'==============================================
Function
'-------------------------------------
Sub
'-------------------------------------
Function
'==============================================
sub/function
'---------------------------
...
and so forth where all of the subs/function separated by the single line are related in some way, or logically should be grouped together, and separate sections which are un-related use the double lines as breaks. Since they are nothing more than comments in the code, they print out just like everything else.
Good Luck
-------------- As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.