ListObject.Range.AutoFilter removes incorrectly filters negative numbers

I have an Excel file to help automate my bookkeeping process. A lot of xml files are imported, analyzed, and the data compiled. I use macros to shorten the process. The issue I'm having is that if I filter the table manually on my tender field by the values "creditCards" and "debitCards", it filters correctly, but if I use vba, it incorrectly hides all rows with a negative in the amount field.

Here is my code:

Please Login or Register  to view this content.

where "list" is my ListObject previously defined, Field1 is my CashierID (I need to filter each one separately; this code repeats), and Field4 is my Tender.

Any ideas as to why this is happening and how to fix it?

That cell contains the Cashier ID, which I have previously extracted from the table. The CashierID does display correctly in all the rows, including those incorrectly filtered, so I do not believe that is the issue.

I do not. Upon further debugging, however, I have noticed that this bug only occurs on the first loop through the code, i.e., for the first CashierID. All others run just fine.

The full loop is as follows:

Please Login or Register  to view this content.

So, I figured out a workaround, though I still do not know what is causing the problems. I tried moving Sheets("Import").ShowAllData to the head of the loop, but it threw an error (because all of the data was already shown). So I put a dummy filter before the loop, and then I have that line at the front, and the problem is solved. I really can't figure out why it behaves that way, and if anyone can figure it out, I'm very interested.

It there is a filter in place beforehand, then why does the ShowAllData method throw an error? I have to create a filter to get that method to work.