Autofilter VBA - Defaults to US date format

[EdwardSurrey]

Hello! I have made a VBA to autofilter based on a date in cell D5. The problem is I'm in the UK and it's taking dates such as 01/04/2022 to mean 04/01/2022. Is there a ways to force it to recognise the British date format?

Sub DateFilter()
'
' DateFilter Macro
'
ActiveSheet.Range("$A$15:$L$300").AutoFilter Field:=10, Criteria1:=">=" & Worksheets("Win Loss Report").Range("D5").Value, Operator:=xlAnd
End Sub

Is there any easy fix? Thanks in advance

 

[RoryA]

Use .Value2 rather than .Value. That will return the date as a number rather than a date, and that can't be misinterpreted.

 

[EdwardSurrey]

Use .Value2 rather than .Value. That will return the date as a number rather than a date, and that can't be misinterpreted.

I'm amazed at how fast you responded to me. I have much to learn! Thank you

 

[RoryA]

Glad we could help.