Hello,

I want to start fresh on a worksheet whenever unloading the userform.

This means deleting all rows on the active worksheet except:
- Row 1 and
- the row that contains the text "Totalt:" in column B. This row is a variable, depending on how many items (rows inserted in between) have been added by the user.

What happens is that every time an option is chosen in a configurator in the userform a row containing data is inserted between the 2 rows mentioned above.

Thus when unloading the userform I want it to start at scratch again, just containing data in the rows above. This is my DEFAULT state if you like.


This is a picture of my desired DEFAULT state of the worksheet:

Screenshot 2014-11-30 16.41.43.png


Thanks in advance