The Word MVP Site

• Word Home
• Word:mac
• Troubleshoot
• Tutorials
• Find Help
• About Us
• Contact
• Sitemap

• Word on the PC
  • Application errors
  • Customization
  • Drawing/Graphics
  • Formatting
  • General
  • Microsoft Word MVP FAQ
  • Macros/VBA
  • Mail merge
  • Numbering
  • Cross-Application dev.
  • Tables, Fields & Forms
  • Userforms
  • Tutorials

• Word on the Macintosh
  • Troubleshooting
  • Customization

What are the underscores _ at the end of lines of code there for?

Article contributed by Dave Rado

A space followed by an underscore tells VBA that the current statement isn't finished yet but continues on the next line – it's used to split a single line of code over two lines, in order to make the code more readable (because VBA doesn't word-wrap).

So rather than:

If Not MyRange.Paragraphs(1).Range.End = MyRange.Sections(1).Range.End Then

you could use:

If Not MyRange.Paragraphs(1).Range.End _
 = MyRange.Sections(1).Range.End Then

But you must insert a space before the underscore. Otherwise (in the above example) the VBA compiler would assume you thought there was such a word as “End_” and would  return an error.