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!