How to Set a Table Style as a Variable

[mcclanat]

Hello,
I am trying to set a table style as a variable without any luck. Below is one example I have been trying (along with several other tests). It would be greatly appreciated if someone would show me how to set a table style as a variable.
Thanks

Please Login or Register  to view this content.

[karedog]

Hi,

You put extra spaces for the TableStyle name :
........TableStyles("Table Style Light 4")

while it should be :
........TableStyles("TableStyleLight4")

To list all available TableStyle, you can use this macro :

Please Login or Register  to view this content.

An example how to use a variable as a TableStyle and apply it to a table (Table = ListObject) named Table1 in activesheet :

Please Login or Register  to view this content.

You may want to check the information from this link :
https://msdn.microsoft.com/en-us/lib...ice.14%29.aspx



Regards