vba
vba - collection 참고
자유프로그램
2017. 5. 20. 12:04
반응형
vba - collection 참고
참고 ;
http://analystcave.com/vba-collection/
https://excelmacromastery.com/excel-vba-collections/
** collection 에 item 존재하는지 검사하기
참고 ; Excel 2016 Power Programming with VBA p.261
Private Function IsInCollection(coll As Collection, item As String) As Boolean
Dim Obj As Object
On Error Resume Next
Set Obj = coll(item)
IsInCollection = Not Obj Is Nothing
End Function
반응형