I have some code that does a great job to count the vbGreen boxes in my spreadsheet. When called it will put a row of totals below the range of cells. The issue is that I need it to act like the subtotal function with a 109 or summing of visible. I will need to filter the entire spreadsheet and it will drop rows out according to category so rather than unnecessarily delete those rows I'd like to make useful the filter then subtotal visible. Here is the current code.
This is called later in another macro by the code:
I understand the code color for the interior color is found and counted but I can't find a similar post that might point me to the modification to count only visible. I am imagining another "if visible then" nested inside so I'll be working on the code while waiting for a response by looking through posts but I'm struggling with the search engine a bit. I need to figure out how to search better but wrapping quote around search words doesn't seem to narrow it down within the Forum search functions. That's another problem I'll address later.
I would really appreciate the help with the modification.
Thank you greatly in advance.