Reset the value in a range

1. Click on View > Toolbars > Control Toolbox
2. Find the Command Button icon and click on it
3. Draw a button shape on your sheet with the mouse
4. Right-click on the CommandButton1 that results and select Properties
5. Find the Caption property in the left panel and change the text in the right panel to RESET GAME
6. On the Control Toolbox Toolbar click on the Design Mode icon (this turns off macros temporarily and lets you edit them)
7. Right-click on the RESET GAME button and select View Code, the VBEditor will open
8. Insert this line of code in empty white space in between the sub flags:
   
   

   Private Sub CommandButton1_Click()
   
       Range("A1:A3,B12,D4:G18,H20").ClearContents
       
   End Sub

   From this code you can see how to list the cells to clear...
9. Edit the cell references to complete the list for your sheet
10. Press Alt-Q to close the VBEditor
11. Click on the Design Mode icon to revert to normal mode
12. Save your sheet

Your new button is ready to use.