无法设置边框类的LineStyle属性? [英] Unable to Set the LineStyle Property of the Border Class?

问题描述

 With Sheets(1).Range(Cells(row + 1, 1), Cells(row + 1, "V"))
     .Interior.ColorIndex = 48
    ' .Borders (xlInsideHorizontal)
 .LineStyle = xlSlantDashDot
 .Weight = xlThin
 .ColorIndex = 15
 .Font.Name = "Times New Roman"
 .Font.Size = 25
     End With

---

    .LineStyle = xlSlantDashDot

这是显示错误的行.

关于MS Office版本吗?

Is it about the MS office version ?

我正在使用MS Officer 2010版本.

I m using MS officer 2010 version .

或者此属性太旧了，我不能使用 xlSlantDashDot .

Or this property is too old ,that I can 't use xlSlantDashDot .

建议使用其他任何excel粗线样式吗?

Any other excel cell thick linestyle suggested ?

错误是

XL2002:错误消息:运行时错误1004:无法设置边框类的LineStyle属性

XL2002: Error Message: Run-Time Error 1004: Unable to Set the LineStyle Property of the Border Class

https://support.microsoft.com/en-us/kb/277577

推荐答案

如果要设置范围的边界，则需要修改行:

If you intend to set the borders of your range, then You need to modify your line:

.LineStyle = xlSlantDashDot

收件人:

.Borders.LineStyle = xlSlantDashDot

这篇关于无法设置边框类的LineStyle属性?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！