multiple line in vba code example
Example 1: 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.
Example 2: how to break a code into below line in vba
Range("G2")="=sumifs(B2:B10,A2:A10," & _
"F2)"