Excel 2007 chart line width + axis labelling with VBA
On Aug 23, 7:32*pm, "Peter T" <peter_t@discussions wrote:
That's the method for formatting the border (ie line) weight in
Excel97-2003, and works in 2007 for compatibility. The .Weight property can
accept any one of four constants, 1, 2, -4138, or 4, also named as
xlHairline, xlThin, xlMedium & xlThick respectively.
Providing your value for 'n' is one of these constants your code will work.
But don't try say 5 (you can apply 3 but it will read back as -4138). For
2007 better to use the method Andy and I suggested.
Regards,
Peter T
Thanks, that's indeed what I've done.
|