Create Table Style Macro Not Producing Expected Results

[mcclanat]

Hello All,
I am trying to create a macro that will create a table style with a thin black line around the table and header cells, dashed grey lines separating cells in the body, and header text bold. I recorded a macro creating the table style format I want, then renamed the style I created and ran the recorded macro. The table style created by the recorded macro does not look the same as the style I created when recording it. The style produced by the recorded macro does not have any of the borders I created, but I can't tell why when I look at the code. An example spreadsheet with the table style I created and the one produced by the recorded macro is attached, and the recorded code is below. I would be greatly appreciated if someone would explain why the macro isn't producing what I expected and/or point me the right direction for how to get a macro to produce what I'm looking for.
Thanks

TableStyleExampleWorkbook.xlsm

Please Login or Register  to view this content.

[Krayvok]

Add this into your macro.

Please Login or Register  to view this content.

[mcclanat]

Thanks for your help. I believe the code gave changes the boarders of the range of the table, but I'm looking to create a table style that can be applied to any table. However, your code gave me a hint and I figured it out. I had to change the line style to .LineStyle = xlContinuous for outside boarders and .LineStyle = xlDash for inside boarders. Thanks again for your help!