Hello all,
I'm trying to draft my own search function from a list found on one sheet.
Function Contactr(target As Long)
Set NOCws = ThisWorkbook.Worksheets("NOC")
Set Conws = ThisWorkbook.Worksheets("Contact")
lrow = Conws.Cells(Rows.Count, 3).End(xlUp).Row
With Conws.Range("C5:C" &...