I came across a quirk for defining Styles in VBA. If I create a new blank style then assign properties to it from a range, everything works EXCEPT Borders. It seems that setting a Style's Border properties from a range requires using the BasedOn parameter for Styles.Add. I'm in the Office Insider's Program at home, and that may have something to do with this. Has anyone else come across this? I don't use Styles much, so this is new for me.
Run the foo macro in the attached workbook to see what happens.
Bookmarks