search in a sheet and selection?

E

EM

What is the easiest way to find a name in sheet1 and select it to do macros
with that particular selected row? This Sheet is huge...
 
B

Bernie Deitrick

EM

In the macro, start off with

Sub HowToFind()
Dim B As Range
Worksheets("Sheet1").Select
Set B = Cells.Find(What:="Name You want to find")
If Not (B Is Nothing) Then
B.Select
Else
MsgBox "Not Found"
Exit Sub
End If
'Other Code here
End Sub

HTH,
Bernie
MS Excel MVP
 
Top