Excel Table Style Modify With VBA

[jstevens]

I'm looking for a resource that will help me understand how to modify an Excel Table's Style using VBA.

Table elements I'm trying to modify: Whole Table, First Column Stripe, Second Column Stripe, First Row Stripe ... Header Row, Total Row ...

[HansV]

I'd record a macro of duplicating an existing table style and modifying it. That will show you the VBA you need.

You'll be changing the items of the TableStyleElements of the TableStyle object.