VBA - Count filtered rows in the table

[DocAElstein]

here is table from csv (100 rows)
with CF defined for each filter (hardcoded) then table filtered by No Color

I don’t know anything about CF or Filters in Excel, so I don’t know what to do with any of that.
Never mind

---

That table looks the same as the Tables and the csv text files we have used so far.


In that last file I added another worksheet, ManuellAlan copied the data range, and then did it all manually
, no VBA
, no PQ
, no CF, filter or anything
, just Alan and his hands very big brain.

Results from me doing it with just my brain and hands:

_____ Workbook: test01.xlsx ( Using Excel 2010 32 bit )

Row\Col	AI
2	Filter name by ll and rr takes out 20 rows, so left with 80
3	Then filter region by sh takes out 2 rows, so 78 left
4	Then filter country by us takes out 3 rows, so I am left wir 75

Worksheet: ManuellAlan



Results from my VBA coding
For this filter set:

, I still get the same results as before:


, and they are the same as when I did it all manually.



So, so far I think my VBA coding is giving the correct results.