This seems like a simple thing but none of us here can figure it out.

I have a date prompt that works as is, with a "=".

Range("AO1").Select

Dim myDate As Date
myDate = InputBox(Prompt:="Enter a date please")
Range("AO1").AutoFilter Field:=41, Criteria1:="=" & myDate

What I WANT to do is return a single date, the myDate. You'd think all you
have to do is remove the , but that returns nothing. Trial and error hasn't
produced a solution.

So simple, but it has us stumped ...

KarenF