Hi everybody,

I'm working on a macro, and needed to know how to write a code with a find formula. I decided to record a simple macro in excel that will do exactly what i want to do. after recording the marco, i tried to run it but it crashes. the code is this:

Sub Macro3()
'
' Macro3 Macro
'

'
    Range("E5:AB5").Select
    Selection.Find(What:="29/01/2016", After:=ActiveCell, LookIn:=xlFormulas _
        , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Activate
    Range("X5").Select
    
End Sub

Can someone help me ?