clearing the sample invoice spreadsheet

I just came across Bob Johnson’s sample_invoice spreadsheet (March 20, 2001) and his articles on error handling and Data Validation drop down lists, which I found very useful.

I’ve modified this to suit my needs but the problem I have is once I’ve printed up an invoice for one customer, and saved it, I would like to clear the name and products on this invoice so I can prepare a new invoice. If I have only 1 product to clear that’s fine but how can I clear, say 20 lines? I’ve been selecting and deleting but that clears all the formulas I’ve entered and then the Data Validation/Drop down lists don’t work.

How can I setup a macro that will clear the cells but still retain the formulas? Or perhaps even have a blank entry appear in the drop down list which I can then select and clear the cell?

Regards
Tas