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.Are there any code examples left?
New code examples in category VBA
Relative searches
excel vba continue line of code
vba make string continue next line
ms access vba continue next line
vba continue on next line
vba how to continue on next line
multiple line in vba
write second line in vba
vba multi statement line
vba code continue on next line in for loop
vba code continue on next line
split lines vba
how to write multiple lines in vba
VBA BREAK LINES
Vba multiline code
break a line of code vba
how to connect a long line in vba code
Continue VBA code on new line in excel
vba underscore
excel split vba lines into more lines
vba split a line of code
vba split code over multiple lines
line continuation in vba
line continuation in statements in vba excel
continue next line vba
vba continue line in quoted string
excel vba continue a line
excel vba how to continue on next line
