Exclude Contents From List :


Hi, What would be your approach to do this job 🙂  Suppose you have 2 List As showing below , and you need to remove List2 contents from List 1 , here is better code to accomplish this job , By using dictionary i just tried to make this process fast 🙂 Sub ExcludeFromList()  …

Unique List From All worksheet.


Get Unique Element from all worksheet at new sheet Sub GetUnique()     Dim wksSheet As Worksheet     Dim VarArr     Dim lngCOunt As Long     With CreateObject(“Scripting.Dictionary”)     For Each wksSheet In ThisWorkbook.Worksheets         VarArr = wksSheet.Range(“A1”).CurrentRegion         For Each kk In VarArr  …