I am trying to automate the creation of a data table. I found a border color that I want to have for the created table. .Color = 15849925 and\or .ColorIndex = 24.
But when I do MyRange.BorderAround xlContinuous, xlThin, 24 the color that appears on the sheet is not the same. It's purplish instead of pale blue. BorderAround also accepts Color instead of ColorIndex, but when I try MyRange.BorderAround xlContinuous, xlThin, , 15849925 it comes out black (no color).
I also tried using the Color argument while ColorIndex was set to xlColorIndexAutomatic or xlColorIndexNone. No difference, it still appears black.
The obvious workaround would be to set the borders without color and then color them each one by one afterward. But I am really wondering what I've done wrong with BorderAround. How can I set the color when using Range.BorderAround?
Excel 2007 12.0.4518.1014