トップページ(目次)

229.罫線_二点鎖線_を引く

<実行前後>
 → 
Sub 罫線_二点鎖線_を引く()

    With Range("B2:C3")
        .Borders(xlEdgeTop).LineStyle = xlDashDotDot '上
        .Borders(xlEdgeBottom).LineStyle = xlDashDotDot '下
        .Borders(xlEdgeRight).LineStyle = xlDashDotDot '右
        .Borders(xlEdgeLeft).LineStyle = xlDashDotDot '左
        .Borders(xlInsideVertical).LineStyle = xlDashDotDot '中の縦
        .Borders(xlInsideHorizontal).LineStyle = xlDashDotDot '中の横
    End With
    
End Sub

Copyright © 2021 https://excel3000.web.fc2.com/ All Rights Reserved.
    inserted by FC2 system