VBA - Count filtered rows in the table

[sandy666]

here is table from csv (100 rows)
with CF defined for each filter (hardcoded) then table filtered by No Color
The trick is that the filter should not be hardcoded
with rows counted manually

[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.