トップページ(目次)

230.罫線を消す②

<実行前後>
 → 
Sub 罫線を消す②()

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

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