procedure Clear;

This example clears data and formatting in cells A1:G37 on sheet one.

Workbook.Worksheets[1].Range['A1', 'G37'].Clear;