Filtering Dates

Hello,

I have created a filter button and unfilter button. It worked when my filter for A column but when I switch to C Column, it seems like it messed up. See attached.

All I did is change this: "A11:A1048576" to "A11:C1048576"

I am trying to filter Start Date: 04/01/24 and End Date: 04/30/24 but not working.


Can someone please fix the code. Thank you in advance.

Please Login or Register  to view this content.

Shouldn't it be C11, rather than A11 (or C4 in your sample sheet) ?

Hope this helps.

Pete

For some Reason it's not working.

Both button for Filter and Unfilter not working.

When I click the filter button, the filter icon showed in A3 and when I click the Unfilter it does not clear the filtered.

Shouldn't it be Field:=3?

Danny

It worked.
but Do I need to change this or leave it?
Thanks

Please Login or Register  to view this content.

I noticed there is something wrong with these.
When I search 4/1 - 4/30/24 the filter in C11.
I set my filter in 3 row but it filters in C11. It should filter from 3 row.

I even change the code to this: A3:C1048576.

Please Login or Register  to view this content.