Just want implement search option in Excel workbook - to search for target
name in rows of the first column.
How to implement this better?

Regards

Would you like the Search to display the row number or select the cell?
--
Gary''s Student - gsnu200751


"SANTANDER" wrote:

Just want implement search option in Excel workbook - to search for target
name in rows of the first column.
How to implement this better?

Regards

"Gary''s Student" wrote in message
...
Would you like the Search to display the row number or select the cell?
--
Gary''s Student - gsnu200751


"SANTANDER" wrote:

Just want implement search option in Excel workbook - to search for
target
name in rows of the first column.
How to implement this better?

Regards

----------
I want that search move me to this row. The rest columns contain the other
relevant info located in the given row.

Sub santander()
Dim s As String
s = Application.InputBox(prompt:="Enter Name to be found: ", Type:=2)
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
If s = Cells(i, 1).Value Then
Application.Goto reference:=Cells(i, 1), scroll:=True
Exit Sub
End If
Next
MsgBox (s & " not found")
End Sub

--
Gary''s Student - gsnu200751