Book.Sheets[1].Range['A5:AL900', EmptyParam].ClearFormats; Book.Sheets[1].Range['A5:AL900', EmptyParam].ClearContents;