Macro to detect duplicates

Hello bakerman2,

Thank you for the response.

When I run the code it debugged on

For i = 1 To UBound(b)

when hovering over it it says "1 = 1002" and Ubound(b)=Type mismatch"?

The data in Import(A:A) and Maps(1:1) are dates, does that make a difference?