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 ?