VBA Macro CountIF each row in a table

[tharrington]

I have a variable set to count the number of rows in a table. And now want to run through each row and count the number of columns in the table that are a certain color, and store this to a new variable without a lot of hard coding. Is this possible? Any ideas of how to go about this would be greatly appreciated. Thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-while-nested-if-post5107790.html#post5107790

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).