엑셀

엑셀 vba Line_Grid_Draw_None

아스C# 2018. 11. 25. 00:30
반응형


Sub Line_Grid_Draw_None(rng As String)

    Range(rng).Borders(xlDiagonalDown).LineStyle = xlNone

    Range(rng).Borders(xlDiagonalUp).LineStyle = xlNone

    Range(rng).Borders(xlEdgeLeft).LineStyle = xlNone

    Range(rng).Borders(xlEdgeTop).LineStyle = xlNone

    Range(rng).Borders(xlEdgeBottom).LineStyle = xlNone

    Range(rng).Borders(xlEdgeRight).LineStyle = xlNone

    Range(rng).Borders(xlInsideVertical).LineStyle = xlNone

    Range(rng).Borders(xlInsideHorizontal).LineStyle = xlNone

End Sub







.




반응형
저작자표시 비영리 변경금지