将“A”列中的所有单元格值添加到数组“ArrV”中!

vbscript
阅读 33 收藏 0 点赞 0 评论 0

UniqueArray.vbs
ArrV = Application.Transpose(Range([a1], Cells(Rows.Count, "A").End(xlUp))) 'Stores all the value in the column 'A' of Sheet 'COUNTRY' to the Array 'ArrV'!
    For I = LBound(ArrV) To UBound(ArrV)    'Uses 'Scripting Dictionary' object to store only unique value!
        ScrDIC(ArrV(I)) = 1
    Next
ArrV = ScrDIC.Keys  'Dumps the Unique values from 'Scripting Dictionary' object into the Array.
评论列表


问题


面经


文章

微信
公众号

扫码关注公众号