Highlight missing or duplicated cells

[Paul_Hossler]

ClearMOST was off by one row. It left the first row of data

Public Const rowHeaderMOST As Long = 4      'MOST Sheet Header Start Row
Public Const rowDataStartMOST As Long = 5   'MOST Sheet Data Start Row

In BuildMOST, change the ZipCode part from .Value to .Text (right at the end of these two)

            .Cells(10).Value = LUV(headerMDS, "Location Street Address", i).Value & " " & LUV(headerMDS, "Location City", i).Value & " " & LUV(headerMDS, "Location State", i).Value & " " & LUV(headerMDS, "Location Zip", i).Text

....

            .Cells(43).Value = LUV(headerMDS, "Location Street Address", i).Value & " " & LUV(headerMDS, "Location City", i).Value & " " & LUV(headerMDS, "Location State", i).Value & " " & LUV(headerMDS, "Location Zip", i).Text

[pawcoyote]

That is what I did and thank you...