Filter will not compile!

[KasperC]

Hello,

Because of the success after my first post, I've decided to come back as I'm quite stuck again..

I'm trying to filter a range of dates for a ceirtan date that is given in cell L1 in the "ws" worksheet, but I can't seem to be able to filter for this value.
(for the record, my date-format is DDMMYYYY. The value in cell L1 has this format: DD.MM.YYYY)

Upon running the sub, a compiling error appears stating that "named argument not found".

Private Sub MySub()
    Dim ws As Worksheet
    Dim wb As Workbook
    Dim adato As String
    
    Set wb = ThisWorkbook
    Set ws = wb.Worksheets("Inn")
    
    adato = Range("L1").Value
    
    ws.Range("C1").AutoFilter Field:=3, Cirteria1:="=01062023" ' <- I want Criteria1 to be "adato", but just for displaying purposes I've changed it to the date/value I want to filter for, in this case "01.06.2023".

End Sub

Does anyone have any idea how to fix this issiue?

Thank you for your time.

Regards,
Kasper C

 

[Joe4]

You misspelled "Criteria":

ws.Range("C1").AutoFilter Field:=3, Cirteria1:="=01062023"

Note: Format has no affect on the criteria. Excel runs on the actual value, not the formatted displayed value.
So you may need to use a valid date entry instead of what you show now (which is not a valid date entry).

 

[KasperC]

Edit:
ws.Range("C1").AutoFilter Field:=3, Cirteria1:="=01.06.2023"

Also, how can I edit my post?

 

[Joe4]

Edit:
ws.Range("C1").AutoFilter Field:=3, Cirteria1:="=01.06.2023"

See my reply.

Also, how can I edit my post?

You cannot edit your own posts until you reach a certain number of posts (I do not remember if it is 10 or 50, off the top of my head).
After that, you have 10 minutes in which to edit it.

 

[KasperC]

See my reply.

You cannot edit your own posts until you reach a certain number of posts (I do not remember if it is 10 or 50, off the top of my head).
After that, you have 10 minutes in which to edit it.

I feel like such an idiot - been looking at this for the past hour..

Also, noted - should probably look closer at the community rules

Thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!