excel表格图案样式怎么设置:【财务报表】

Excel表格图案样式的设置可以通过设置单元格的边框、填充颜色、字体颜色等来实现。下面是一个示例代码,用于设置单元格的边框、填充颜色和字体颜色:

Excel表格图案样式的设置可以通过设置单元格的边框、填充颜色、字体颜色等来实现。是一个示例代码,用于设置单元格的边框、填充颜色和字体颜色:

Excel表格图案样式的设置可以通过设置单元格的边框、填充颜色、字体颜色等来实现。

是一个示例代码,用于设置单元格的边框、填充颜色和字体颜色:

Sub SetStyle()

'设置A1:B2单元格的边框、填充颜色和字体颜色

Range("A1:B2").Select

With Selection.Interior

.Pattern = xlSolid

.PatternColorIndex = xlAutomatic

.Color = 5296274

.TintAndShade = 0

.PatternTintAndShade = 0

End With

With Selection.Font

.Color = -16776961

.TintAndShade = 0

End With

Selection.Borders(xlDiagonalDown).LineStyle = xlNone

Selection.Borders(xlDiagonalUp).LineStyle = xlNone

With Selection.Borders(xlEdgeLeft)

.LineStyle = xlContinuous

.ColorIndex = 0

.TintAndShade = 0

.Weight = xlThin

End With

With Selection.Borders(xlEdgeTop)

.LineStyle = xlContinuous

.ColorIndex = 0

.TintAndShade = 0

.Weight = xlThin

End With

With Selection.Borders(xlEdgeBottom)

.LineStyle = xlContinuous

.ColorIndex = 0

.TintAndShade = 0

.Weight = xlThin

End With

With Selection.Borders(xlEdgeRight)

.LineStyle = xlContinuous

.ColorIndex = 0

.TintAndShade = 0

.Weight = xlThin

End With

With Selection.Borders(xlInsideVertical)

.LineStyle = xlContinuous

.ColorIndex = 0

.TintAndShade = 0

.Weight = xlThin

End With

With Selection.Borders(xlInsideHorizontal)

.LineStyle = xlContinuous

.ColorIndex = 0

.TintAndShade = 0

.Weight = xlThin

End With

End Sub

本站系公益性非盈利分享网址,本文来自用户投稿,不代表码文网立场,如若转载,请注明出处

(347)
cvt变速箱怎么保养:如何正确保养CVT变速箱?
上一篇
cvt变速箱阀体故障表现cvt变速箱阀体故障
下一篇

相关推荐

发表评论

登录 后才能评论

评论列表(13条)