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.
Bookmarks