ListObject.ShowTotals (Excel)

Gets or sets a Boolean to indicate whether the Total row is visible.

ActiveCell.ListObject.ShowTotals = True