Share via

Application.EditClear Method

  • Article
Project Developer Reference

Clears the selected cells.

Syntax

expression.EditClear(Contents, Formats, Notes, Hyperlinks)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Contents Optional Boolean True if the contents of the selected cells are cleared. The default value is True.
Formats Optional Boolean True if the formats of the selected cells are cleared. The default value is False.
Notes Optional Boolean True if the notes of the assignment, resource, or task in the selected cells are cleared. The default value is False.
Hyperlinks Optional Boolean True if the hyperlinks associated with the selected cells are removed. The default value is False.

Return Value
Boolean

Example
The following example clears the contents, formats, and notes of the selected cells.

Visual Basic for Applications 
  Sub ClearAll()
    EditClear True, True, True
End Sub

See Also