I have a great WS that Martin Liss has helped create for a situation where you make choices by clicking black boxes (in Col. A) and the selection changes the color (to show selection) and it runs through some math to produce a result at the bottom of each table.
Here's the issue. We now have the ability to "clear the list of selections (The CLEAR BUTTON). While it does clear the selections, it doesn't reset the math to have -0- at the bottom of the cells at the bottom of each table. I need someone to look at this macro under the CLEAR Button and figure out what needs to be added in order to reset the tables and math at the bottom of each Table.
Make sure you make a copy of the original WB; when you start troubleshooting the Macro, you will find that you can't go back to the start.
Thank you in advance,