Guest User

Untitled

a guest
Jul 17th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. Sub Sample()
  2.  
  3. Dim lastRow As Integer
  4. Dim rng As Range
  5. lastRow = Sheets("Sheet1").Range("A65000").End(xlUp).Row
  6.  
  7. For i = 1 To lastRow
  8. Set rng = Sheets("sheet2").Range("A:A").Find(Sheets("Sheet1").Cells(i, 1))
  9. If rng Is Nothing Then
  10. Sheets("Sheet1").Cells(i, 1).EntireRow.Interior.Color = vbRed
  11. End If
  12. Next
  13. End Sub
Add Comment
Please, Sign In to add comment