I have two columns with 2 players and 7 Buttons assigned to each that should add a value of 1 to 7 points to a "Total"-Cell (say B4 and D4) that totals the points (=adds to the previous total) whenever I click the respective Button. I entered the values of 1 to 7 into a (hidden) column (AA), where the respective Buttons could take the values from.

I ended up with a circular reference, whenever I wanted to add a value to the "Total" cell with the formula =B4+AA1 in B4.



I thought of a solution to enter the values after each click of a Button into a (hidden) column and use the SUM of this column to be put into the "Total"-Cell, but how will the Macro find the next free Cell in that hidden column...?

Thanks a million for any help.