위키
포럼
도구
바뀐글
랜덤

"엑셀 매크로 시트 있는지 확인"의 두 판 사이의 차이

(새 문서: <source lang='vb'> Public Function exist_worksheet(ByVal name As String) As Boolean exist_worksheet = False For Each ws In ActiveWorkbook.Worksheets If ws.name = name ...)
 
1번째 줄: 1번째 줄:
<source lang='vb'>
<source lang='vb'>
Public Function exist_worksheet(ByVal name As String) As Boolean
Public Function exist_worksheet(name As String) As Boolean
     exist_worksheet = False
     exist_worksheet = False
     For Each ws In ActiveWorkbook.Worksheets
     For Each ws In ActiveWorkbook.Worksheets

2012년 4월 2일 (월) 00:17 판

Public Function exist_worksheet(name As String) As Boolean
    exist_worksheet = False
    For Each ws In ActiveWorkbook.Worksheets
        If ws.name = name Then exist_worksheet = True
    Next ws
End Function
원본 주소 "https://zetawiki.com/w/index.php?title=엑셀_매크로_시트_있는지_확인&oldid=4477"
문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}