ListRow.Delete Method (Excel)
Deletes the cells of the list row and shifts upward any remaining cells below the deleted row. You can delete rows in the list even when the list is linked to a SharePoint site. The list on the SharePoint site will not be updated, however, until you synchronize your changes.
Syntax
expression .Delete
expression A variable that represents a ListRow object.