Guest User

Untitled

a guest
Jul 1st, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. Sub Finder()
  2.  
  3. Dim WhereToSearch As Range, WhatToSearch As Range, ValueFound As Range, ValueSearched As Range
  4.  
  5. Set WhereToSearch = ActiveSheet.Range("K4:K6525")
  6. Set WhatToSearch = ActiveSheet.Range("J4:J6525")
  7.  
  8.  
  9. For Each ValueSearched In WhatToSearch
  10.  
  11. Set ValueFound = WhereToSearch.Find(What:=ValueSearched, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
  12.  
  13. If Not ValueFound Is Nothing Then
  14.  
  15.  
  16. ValueFound.Offset(0, 2) = ValueFound
  17.  
  18.  
  19. End If
  20. Next
  21. End Sub
Add Comment
Please, Sign In to add comment