Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba how to continue on next line

Excel Hero answered on March 26, 2020 Popularity 8/10 Helpfulness 1/10

answer excel vba how to continue on next line

excel vba how to continue on next line

Comment

'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.

Popularity 8/10 Helpfulness 1/10 Language vb

Source: Grepper

Tags: continue excel line next vba

Link to this answer
Share Copy Link

Contributed on Mar 26 2020

Excel Hero

0 Answers Avg Quality 2/10

excel vba how to continue on next line

Contents

More Related Answers

excel vba how to continue on next line

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.