title: Excel VBA Find data in two columns on a single row
body: <p>I'm trying to make this code find a row where column V is not equal to "Y" or "L" AND column A is not blank.  I think I'm overdoing it a bit, I'm sure there is an easier way to check both cells on the row.</p>
  
  <pre><code>Sub EndMove()
  Dim Col1 As Integer, Col2 As Integer, rowCount As Integer, currentRow As Integer
  Dim currentRowValue As String, currentRowValue2 As String
  
  Col1 = 22
  Col2 = 1
  rowCount = Cells(Rows.Count, Col1).End(xlUp).row
  
  For currentRow = 1 To rowCount
      currentRowValue = Cells(currentRow, Col1).Value
      If currentRowValue &lt;&gt; "y" Or currentRowValue &lt;&gt; "l" Then
      currentRowValue2 = Cells(currentRow, Col2).Value
      If Not IsEmpty(currentRowValue2) Then
      Cells(currentRow, Col1).Select
      MsgBox "Move this?"
  End If
  End If
  Next
  </code></pre>
  
  <p>End Sub</p>
  
  <p>Thanks</p>