Create a Table Style With VBA

I am trying to create a few table styles using VBA. I'm having a difficult time of finding examples on the internet. I keep getting an "Application-defined or object-defined" error when I start modifying the color properties, ".Interior.PatternColorIndex = -4105".

Using the Watch tool I can see the property is there. What I'm doing wrong to get this error? Thanks!

Please Login or Register  to view this content.

Copying and pasting your code worked fine for me. -4105 = xlAutomatic. Are you changing this to other values? I don't tend to use patterns, but after a bit of playing around, it looks like only values from -1 to 56 work (and -4105).

Originally Posted by mgs73

Copying and pasting your code worked fine for me. -4105 = xlAutomatic. Are you changing this to other values? I don't tend to use patterns, but after a bit of playing around, it looks like only values from -1 to 56 work (and -4105).

😖 It’s working for me now as well. Not sure what was going on earlier other than I probably should have taken a break and walked away for a little bit.

In answer to your question I was using xlAutomatic but switched to the integer in hopes that maybe that was causing an issue. Thank you for “fixing” it for me. 😉