title: How to Break a Long Line of Code Into Multiple Lines in VBA
body: <p>I have a long of code that I would like to break up in two lines. I know we usually use <code>_</code> and go to the next line, but as I am breaking up a list in a nested function I get the error:</p>
  <blockquote>
  <p>Compile error: Expected: list separator or )</p>
  </blockquote>
  <p>The code works fine otherwise.</p>
  <p>The line I want to split up is the second one: If Not Intersect(Target, Range [...])</p>
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
      If Not Intersect(Target, Range(&quot;F6:F1000000, G6:G1000000, K6:K1000000, L6:L1000000, P6:P1000000, Q6:Q1000000, U6:U1000000, V6:V1000000, Z6:Z1000000, AA6:AA1000000, AE6:AE1000000, AF6:AF1000000&quot;)) Is Nothing Then
          Application.EnableEvents = False
          If ActiveCell.Value = ChrW(&amp;H2713) Then
              ActiveCell.ClearContents
          Else
              ActiveCell.Value = ChrW(&amp;H2713)
          End If
          Cancel = True
      End If
      Application.EnableEvents = True
  End Sub
  </code></pre>
  <p>Thank you.</p>