Store border information in arrays

[Un-Do Re-Do]

I'm using this macro to store Border information in arrays.
In this instance, at Page Breaks. Recording Line Style, Weight and Colour.
It stores information as Long & Double.

For some reason, when there is no border, the LineStyle is -4142, and the Weight is 2.

Is there a reason for this?

Edit: The Line Style enumerations can be found here:
https://docs.microsoft.com/en-us/off...el.xllinestyle
But the Weight should be zero.


Snapshot.png

Please Login or Register  to view this content.

[rorya]

The xlBorderWeight enum has 4 values (xlThin, xlMedium, xlHairline and xlThick), none of which has the value 0. 2 is xlThin, which is the default.

[Un-Do Re-Do]

OK, thanks for clarifying.