GP Fault If Many Line Continuation Characters in Module

MORE INFORMATION

When you enter code in a Visual Basic module in Microsoft Excel, you can use an underscore (_) as a line-continuation character. When you type this character at the end of a line, the next line is appended to the current line when you run the subroutine.

For example, when you run the following code

   Example = "Test 1 " & _
      "Test 2"
				

the line is evaluated as if you typed it as follows:

   Example = "Test 1 " & "Test 2"
				

Normally, you can type up to nine consecutive lines with line-continuation characters. If you type a tenth consecutive line with a line-continuation character, you will receive the error message and the tenth line-continuation character is automatically removed.

However, when you copy and paste consecutive lines that end in a line- continuation character, you can easily exceed the nine line limit. When you do this, you receive the error message above as expected. Additionally, the screen may be redrawn incorrectly; lines in your procedure may be missing and others may display twice. You may also receive a GP Fault.