トップページ(目次)

227.罫線_破線_を引く

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

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

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