search in excel

[clint]

I want to make a search for a number or a string in excel. Is there anyone who can help me? Regards. Clint

[Joacim Andersson]

'this code assumes you have declared and created the
'Excel.Application object and called it xl
    xl.Cells.Find(What:="TheStringToSearchFor", _
     After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
     xlPart, SearchOrder:=xlByRows, _
     SearchDirection:=xlNext, MatchCase:=False).Activate

Good luck!

[clint]

thank you very much. you are great.

[clint]

joacim, could u please show me how to declare variables such as ActiveCell? When I run the code, it gives "variable not defined" error message.

[Joacim Andersson]

Sorry it should say: xl.ActiveCell
ActiveCell is a property of the Excel.Application object.