LinkBack URL
About LinkBacks
In a column 3 I tend to keep on accumulating values that need to be removed. I now have too many values in that column now that I am getting an error of "Too many line continuations." How do I resolve this?
For i = Cells(Rows.Count, 3).End(xlUp).Row To 1 Step -1
If Cells(i, 4).Value = "INIT" Or Cells(i, 4).Value = "DES" Or _
Cells(i, 3).Value = 1908425 Or _
Cells(i, 3).Value = 1632492 Or _
Cells(i, 3).Value = 2588948 Or _
Cells(i, 3).Value = 2644451 Or _
Cells(i, 3).Value = 2654319 Or _
Cells(i, 3).Value = 1794637 Or _
Cells(i, 3).Value = 1722139 Or _
Cells(i, 3).Value = 2655788 Or _
Cells(i, 3).Value = 1796065 Or _
Cells(i, 3).Value = 1489608 Or _
Cells(i, 3).Value = 1794637 Or _
Cells(i, 3).Value = 1770914 Or _
Cells(i, 3).Value = 1495217 Or _
Cells(i, 3).Value = 1492028 Or _
Cells(i, 3).Value = 1983020 Or _
Cells(i, 3).Value = 2122683 Or _
Cells(i, 3).Value = 1507671 Or _
Cells(i, 3).Value = 1593761 Or _
Cells(i, 3).Value = 2458957 Or _
Cells(i, 3).Value = 1782458 Or _
Cells(i, 3).Value = 2240527 Or _
Cells(i, 3).Value = 2319018 Or _
Cells(i, 3).Value = 2084908 Or _
Cells(i, 3).Value = 2029397 Or _
Cells(i, 3).Value = 1896445 Or _
Cells(i, 3).Value = 1908373 And Cells(i, 22) = 11400 Or _
Cells(i, 5).Value = "1234567" Or Cells(i, 5).Value = "1234567" Then _
Rows(i).Delete
Next
For Each cell In ActiveSheet.UsedRange
cell.Value = Trim(cell)
Next cell
Thanks for the help.
Register To Reply
below the post.
Bookmarks