Formatting a worksheet using VBA fails when using the LineStyle property.
Whatever linestyle, reading the property always return the value 1.
Setting the property doesn't change the linestyle.
Example: Range("B2").Borders(xlEdgeBottom).LineStyle = xlContinuous
Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?