borderAround optional parameters

[par60056]

I looked at the documentation for Range().BorderAround and it is unclear what it does if you leave out the optional parameters.

The reason for this post is informational.

Excel 2011 (mac) behaves differently from Excel 2010 (Windows). The mac alters the linestyle, weight and color and sets them to the default xlcontinuous, xlthin and black. Excel 2010 leaves them with the current values.

I was writing something to make a simple wall calendar. I set the color and weight on the borders collection for the entire area I was going to use. The I selected smaller ranges and said borderaround. This worked fine on the PC but on the mac all the color and weight reset.

 

[par60056]

Still, now that you are aware of the differences, simply use conditional formatting to accommodate the slightly different behavior. Whether one side has it “right” and the other side has it “wrong” doesn’t really matter. As a programmer, you just program for the difference and get on with your life. Because of possible complications with existing code, I doubt Microsoft would change either platform’s behavior even if we reported this as a bug on the Windows side.

If you look at the original post, I said:

The reason for this post is informational.

I had the solution I was just trying to make other people aware.

I don't know why I would use conditional coding. Since 1 way works on both and 1 way doesn't, I would just always use the way that works on both. Or even easier I can just put the parameters for the color and thickness on the call to borderAround and not have to worry about it.

As a programmer I try to avoid making code that is hard to maintain by having different routines to do the same thing when having 1 will work just fine. As a programmer I try to share the information so that somebody else can see that a solution was already found.

Thank you for trying to help solve a problem that I had already solved.