par60056
Well-known Member
- Joined
- Jul 26, 2012
- Messages
- 1,581
- Office Version
- 2011
- 2010
- Platform
- Windows
- MacOS
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.
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.