this is in Excel VBA.
I am trying to set the filter for the list data, as the test i am coding the 07.0 entry to filter on, but the filter is not taking place. If I change the filter to the 20.0.3 or 20.0.1 or any value that was letters in it, it will filter correctly. I will not filter correctly on 07.0, 26.0, or 19.0. this are text based values not numeric.

I have a very strange problem. I have a large Excel data set (100k+ rows) with an autofilter. The autofilter runs fine on the main sheet, but after running some code (does multiple calculations and then hard codes the values) the autofilter then runs very slow. Every time I change or clear a filter (previously took 1 second, now takes 10+ seconds).

I am working on a macro program for this sheet of information. It should filter by Completion Date and blanks, as well as filtering by Status. The statuses I want are In Queue and Completed. This should result in a sheet that shows me what was completed on the date Input, what’s In Queue, as well as blanks which will let me know that a batch was not completed today.

I would like to autofilter a data set/field that doesn’t have a header