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)"

Tags:

Vb Example