ActiveX

To delete the data and cell characteristics from a cell or block of cells

Call the ClearRange method and set the DataOnly parameter to FALSE.