Application.EditClear method (Project)
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.
Sub ClearAll()
EditClear True, True, True
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.