티스토리 뷰
반응형
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 |
댓글