VBA to find a date in a range

[BillDoor]

Hi all

I have the below code, which I have used in other sheets, but I can not seem to get it to work in the attached, it's driving me a little nuts, can some one please point out whatever stupid mistake I am making!


All I want it to do is find the cell in the row 3 that matches the date in C1
thanks

Sub test()
        
        Dim MonthCopy As Variant
        
        MonthCopy = Range(Trim("C1")).Value
        
        Rows("3:3").Select
        Selection.Find(what:=MonthCopy, LookIn:=xlValues, LookAt:=xlWhole, _
        SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Activate
        
        
End Sub