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 ...
Excel Table Style Modify With VBA
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Excel Table Style Modify With VBA
Regards,
John
John
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel Table Style Modify With VBA
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.
You'll be changing the items of the TableStyleElements of the TableStyle object.
Best wishes,
Hans
Hans