Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I delete data in a cell without deleting formula? | Excel Worksheet Functions | |||
Deleting the text without deleting the formula | Excel Worksheet Functions | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
Deleting formula in data validation list | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |