Line Continuation

[goss]

Hi all,

Using Excel 2010 Beta

I am receiving the following error in this snippet:

Compile error:
Expected: end of statement

I think it is because of my line continuation, am I not using it correctly?

str1 = "Marbles"
str2 = "Checkers"
    
    With wsData
            Do While index <= lngRows
                If InStr(.Range(index, 4), str1) Then
                    If InStr(.Range(index, 4).Offset(1, 0), str2) Then
                        .Range(index, 4).Value = "TOTAL MARBLES" _
                        .Range(index, 4).Offset(1, 0).Value = "TOTAL CHECKERS"
                        
                End If
                lngRows = lngRows - 1
            Loop
    End With

 

[Bill Rockenbach]

I think you left out an "end If" statement

    With wsData
            Do While index <= lngRows
                If InStr(.Range(index, 4), str1) Then
                    If InStr(.Range(index, 4).Offset(1, 0), str2) Then
                        .Range(index, 4).Value = "TOTAL MARBLES" _
                        .Range(index, 4).Offset(1, 0).Value = "TOTAL CHECKERS"
                     [COLOR=red]End If[/COLOR]  
                End If
                lngRows = lngRows - 1
            Loop
    End With