search in a sheet and selection?

  • Thread starter Thread starter EM
  • Start date Start date
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...
 
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
 
I would probably use FIND
myrow=columns(1).find("jones").row
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Form cells (WS1) to Database (WS2) 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Macro Question 3
Sheet name list 4
Excel 2007: Help creating a macro that will run Solver? 3
Using a button to select cells on different worksheets 3
Excel help with Macro code in excel 1
Macro to copy value in field and insert it into filter 2

Back
Top