Deleting data but not formula
 

assume data is entered in the range B9:G30 and some of the cells may have
formulas, but don't contain labels you want to retain.

on Error Resume Next
range("B9:G30").SpecialCells(xlConstants).Clearcon tents
On Error goto 0

--
Regards,
Tom Ogilvy

"La Durande" wrote in message
...
Am using a template to produce invoices and after saving the finished
invoice
as aa xls I require to clear the template in order to produce the next
invoice without having to close (without saving) & then reopen the
template.