Dictionary 썸네일형 리스트형 🧨 엑셀 VBA / Dictionary 개체_실무 출처: https://lesserpainbetterlife.tistory.com/803 [전진수블로그 ✝ = ♥ 유배자의 영성:티스토리] 코딩 편집 Option Explicit Sub PDictionary() Dim rng As Range, c As Range, rngT As Range Dim dict As New Scripting.Dictionary Dim i As Long Dim s Application.ScreenUpdating = False Range("d1").CurrentRegion.ClearContents Range("a1").CurrentRegion.Copy Range("d1") Range("d1").CurrentRegion.RemoveDuplicates Array(1, 2), xlYes .. 더보기 🧨 엑셀 VBA / 배열, New Collection, Dictionary 배열 : 한 방에 in, out New Collection : 고유 목록 Dictionary : 고유 목록, 중복된 값이 있으면... (참고 동영상) https://youtu.be/1yBE6MGkIA4 더보기 New Scripting.Dictionary 예제 (동영상 연결) (참고 동영상) https://youtu.be/1yBE6MGkIA4 Option Explicit Sub PDictionary() Dim rng As Range, c As Range, rngT As Range Dim dict As New Scripting.Dictionary Dim i As Long Dim s Application.ScreenUpdating = False Range("d1").CurrentRegion.ClearContents Range("a1").CurrentRegion.Copy Range("d1") Range("d1").CurrentRegion.RemoveDuplicates Array(1, 2), xlYes Set rng = Range("d2", Cells(Rows.Count, "d")... 더보기 이전 1 다음
