トップページ(目次)

232.罫線_点線_を引く

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

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

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