ClearContents Method Example
This example deletes all data from column two on the active worksheet.
Spreadsheet1.ActiveSheet.Columns(2).ClearContents