Start a new line in IF without compile error

**strud** · 10-07-2013, 04:24 AM

Is it possible to start a new line in an IF without the compile error (i.el that there is no 'Then'). So I have the line:

If Not vData(i, 2) = vCriteria And Not vData(i, 3) = vCriteria And Not vData(i, 4) = vCriteria And Not vData(i, 5) = vCriteria And Not vData(i, 6) = vCriteria And Not vData(i, 7) = vCriteria And Not vData(i, 8) = vCriteria And Not vData(i, 9) = vCriteria And Not vData(i, 10) = vCriteria Then

I want to start a new line say half way through so I don't have to side scroll to see it- but if I do that because the line doesn't end with a 'Then' there is a compile error.

Alternatively, is there way I could just condense my line?

Even if this is possible it would still be useful to know the answer to the original question though.

Thanks guys

**benishiryo** · 10-07-2013, 04:31 AM

hi strud. put a space & an underscore:

If Not vData(i, 2) = vCriteria And Not vData(i, 3) = vCriteria And Not vData(i, 4) = vCriteria And Not vData(i, 5) = _
vCriteria And Not vData(i, 6) = vCriteria And Not vData(i, 7) = vCriteria And Not vData(i, 8) = vCriteria And Not vData(i, 9) _
= vCriteria And Not vData(i, 10) = vCriteria Then

**Andy Pope** · 10-07-2013, 04:32 AM

    If Not vData(i, 2) = vCriteria And _
       Not vData(i, 3) = vCriteria And _
       Not vData(i, 4) = vCriteria And _
       Not vData(i, 5) = vCriteria And _
       Not vData(i, 6) = vCriteria And _
       Not vData(i, 7) = vCriteria And _
       Not vData(i, 8) = vCriteria And _
       Not vData(i, 9) = vCriteria And _
       Not vData(i, 10) = vCriteria Then
       
    End If

**strud** · 10-07-2013, 04:39 AM

Thanks for the help guys

Start a new line in IF without compile error

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Start a new line in IF without compile error

Re: Start a new line in IF without compile error

Re: Start a new line in IF without compile error

Re: Start a new line in IF without compile error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library

[SOLVED] Continue code on next line: Compile Error: expected list separator or )

Compile error in vba code in one line

GoTo compile error: "Expected: line number or label"

Syntax Error and Compile Error: Expected Line Number or Label...

Bookmarks

Bookmarks

Posting Permissions