I am having an issue when filtering a column to search for all 2011 and 2012 dates. Here is my current code:
assessSheet.Range("$A$1:$BG$2000").AutoFilter Field:=9, Criteria1:="=*2012*" _
, Operator:=xlOr, Criteria2:="=*2011*"
This generally works fine, but when I add new rows of data to the end of my spreadsheet, the dates will not format correctly. I have tried copying the format of the correct rows to the rows with the issue, but it still will not work. I also noticed that the correct dates' format appears to be different from the issue dates' format. (See attached images).
Also, when I open the "More Number Formats", both of them are on the same format as seen in the following image:
I am not sure how to fix this issue.. even though it seems pretty simple. I am not able to share my spreadsheet either.. Does someone know how to fix this issue?
Thanks in advance,