Did you already try this ?
![]()
Set findvalue = ThisWorkbook.Worksheets("cc_output").Range("A:A").Find(What:=CC_ID, LookIn:=xlValues, LookAt:=xlWhole).Offset(0, 0)
Did you already try this ?
![]()
Set findvalue = ThisWorkbook.Worksheets("cc_output").Range("A:A").Find(What:=CC_ID, LookIn:=xlValues, LookAt:=xlWhole).Offset(0, 0)
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks