This procedure deletes a table from an existing Excel worksheet by clearing the contents of cells within the specified table dimensions.
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
delete the table in the worksheet
What does it do?
Begins table deletion from the current worksheet.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required.
Does it require data?
✅ Yes — A reference to the worksheet must be defined in the automation.
the location is "A1"
What does it do?
Specifies the top-left corner of the table to delete.
Where does it go?
Indented under delete the table in the worksheet where
.
Is it required?
✅ Yes — This phrase is required.
Does it require data?
✅ Yes — Replace A1 with a cell reference (e.g., "A1", "B2").
Example
the height is h
What does it do?
Specifies the number of rows in the table.
Where does it go?
Indented under delete the table in the worksheet where
.
Is it required?
✅ Yes — This phrase is required.
Does it require data?
✅ Yes — Replace h with a numeric value representing table height.
Example
the width is w
What does it do?
Specifies the number of columns in the table.
Where does it go?
Indented under delete the table in the worksheet where
.
Is it required?
✅ Yes — This phrase is required.
Does it require data?
✅ Yes — Replace w with a numeric value representing table width.
Example
delete the table in the worksheet where
the location is "B2"
the height is 5
the width is 4