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
Bookmarks