It works for me.I ran the code with some sample data. However, it came back with a total count of 0, when it should have come back with 4. Any thoughts as to why it might not be detecting or counting the cells with a red background? Thank you your help. I appreciate it.
See fileHTH
Bookmarks