=MATCH(51477, A:A, 1) + 1
Public Sub findit()
Cells(Application.WorksheetFunction.Match(Range("C1"), Range("A:A"), 1) + 1, "C").Select
End Sub
Is there code to say whatever cell is active, copy and paste the current user input from C2?
ActiveCell = Range("C2").Value
@RoseGuy: Welcome to the MrExcel Message Board, and great to see you got the solution to your question!Thank you very much. That works for what I need.