티스토리 뷰

엑셀

엑셀 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







.




반응형

'엑셀' 카테고리의 다른 글

엑셀 vba 들여쓰기_초기화  (0) 2018.11.26
엑셀 vba 입력자동화_비우기(  (0) 2018.11.25
Line_Grid_Draw  (0) 2018.11.25
엑셀 vba func_Print_Seting 프린터 설정  (0) 2018.11.24
엑셀 vba 출력_업체시트  (0) 2018.11.24
댓글