Continue VBA code on new line in excel code example
Example: excel vba how to continue on next line
'VBA uses the combination of a Space character AND an Underscore to
'continue a line of code to the next line.
'For example:
MyVariable = ThisWorkbook.Worksheets("Sheet1").Range("A1").Value & _
ThisWorkbook.Worksheets("Sheet2").Range("A1").Value
'------------------------------------------------------------------
'Caveat 1: The line break is not allowed
' in the middle of quoted literal text.
'Caveat 2: The line break can only happen where a Space character
' would be allowed. For example, you are not allowed to
' split up dot notation for an object's scope and
' properties and methods.
'Caveat 3: One line of code can have a maximum of 24 line breaks.
'Caveat 4: One line of code can have a max of 1024 characters,
' whether it is continued or not.