Excel VBA Borders.TintAndShade corrupting cells in 360 64 bit but works fine in 2016 32 bit

Question

The following snippet works fine in Excel 2016 32bit to set cell borders. However, the same code crashes in Excel 360 64bit with an error on what ever method accesses the border object immediately following the .TintAndShade. If the script is exited after the .TintAndShade without accessing the border object again, the workbook will not save. Excel reports it as corrupted and cannot recover it, even though it looks fine on the screen. It appears that something in the .TintAndShade and nuking the cell border.

I was able to work around this just by not setting .TintAndShade and leaving it as the default, so I don't really need a workaround. I would like to know if this is a known issue or if I am using .TintAndShade wrong?

Thoughts?

<selecting some range of cells>

With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 1
.TintAndShade = 0
.Weight = xlThin
End With

Thanks,
G^2

Answer 1

Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

--please don't forget to Accept as answer if the reply is helpful--