excel - VBA - Delete previously saved values

Question

I have a sheet where I store the values the user selected.

I have a userform pop-up with a warning saying: "There are previously saved values. Do you want to keep them? If they say yes, all good, but if they say no I need to delete the previously saved values.

This userform appears in the middle of the process (not possible to change), so there will already be new saved values that I need to keep.

I though of having some index number, for example the first saved values get a 1, the next saved batch get a 2. Then, if I wanted to delete I would just have to delete the older batch. However, I'm not sure how to implement this.

Any suggestions??

question from:https://stackoverflow.com/questions/65841754/vba-delete-previously-saved-values

Answer 1

how about you clear range where data is stored with Worksheets("Sheet1").Range("A1:G37").Clear if you press NO and then write new data, in rows bellow title, but if you press YES, then determine last row in column where data is stored and write data in next row.