Clear method

Clears a TableData object. Returns True if successful, otherwise False.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
✓

Parameters

Name	Type	Description
Contents	Boolean (optional)	Clears contents (default is True).
Formats	ClearOptions enumeration (optional)	Clears format. Options are ClearAllRows, ClearExceptFirstRow or DoNotClear (default).
Borders	Boolean (optional)	Clears borders.
Filters	Boolean (optional	Switches off autofilter.
Headers	Boolean (optional)	Clears all borders.
DataValidation	ClearOptions enumeration (optional)	Clears data validation. Options are ClearAllRows, ClearExceptFirstRow or DoNotClear (default).
Comments	Boolean (optional)	Clears comments.

Clear clears various parts of the TableData object, depending on which options are selected.