Advertisement
Guest User

Untitled

a guest
Oct 10th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. Sub Test1()
  3.     Dim sh As Worksheet
  4.     Dim sh2 As Worksheet
  5. Dim rw As Range
  6. Dim i As Integer, k As Integer, j As Integer
  7. Set sh2 = Sheets("enova")
  8. Set sh = Sheets("klient")
  9. k = sh.UsedRange.Rows.Count
  10. j = sh2.UsedRange.Rows.Count
  11.  
  12. For i = 2 To k
  13.      If Application.WorksheetFunction.CountIf(sh2.Range(sh2.Cells(2, 1), sh2.Cells(j, 1)), sh.Cells(i, 1).Value) > 0 Then
  14.         sh.Cells(i, 1).Interior.Color = RGB(255, 255, 255)
  15.     Else
  16.         sh.Cells(i, 1).Interior.Color = RGB(255, 255, 0)
  17.     End If
  18. Next i
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement