All the code preceding this line work just fine, and this line of code dumps myArr into column A2 of Sheet("A Name of Sheet") and down 12,000 rows.
Of those 12,000 entries, there are 0 to 7 duplicates on any give execution of the code.
How can I remove those duplicates, if they do occur from myArr before dumping into column A?
Thanks.
Howard
Of those 12,000 entries, there are 0 to 7 duplicates on any give execution of the code.
How can I remove those duplicates, if they do occur from myArr before dumping into column A?
Code:
myArr = .Range("A2:A" & LRow)
Thanks.
Howard