I'd like to put a reset button into a spreadsheet so that I can reset the value of certain cells in a range at the start of a new payment cycle. Here is the code I have so far:
Private Sub CommandButton1_Click()
Range("U:U") = "STATUS (CHOOSE):"
End Sub
Unfortunately there are a lot of cells that must remain blank in the range and this will populate all cells. Thankfully I need to change all populated cells in the range to "STATUS (CHOOSE):". I'm setting the range to cover the entire column so that the sheet can expand without issue.
Any help will be appreciate.
Thanks,
Jeff
Private Sub CommandButton1_Click()
Range("U:U") = "STATUS (CHOOSE):"
End Sub
Unfortunately there are a lot of cells that must remain blank in the range and this will populate all cells. Thankfully I need to change all populated cells in the range to "STATUS (CHOOSE):". I'm setting the range to cover the entire column so that the sheet can expand without issue.
Any help will be appreciate.
Thanks,
Jeff