Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Finder()
- Dim WhereToSearch As Range, WhatToSearch As Range, ValueFound As Range, ValueSearched As Range
- Set WhereToSearch = ActiveSheet.Range("K4:K6525")
- Set WhatToSearch = ActiveSheet.Range("J4:J6525")
- For Each ValueSearched In WhatToSearch
- Set ValueFound = WhereToSearch.Find(What:=ValueSearched, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
- If Not ValueFound Is Nothing Then
- ValueFound.Offset(0, 2) = ValueFound
- End If
- Next
- End Sub
Add Comment
Please, Sign In to add comment