Help with VBA mass find and replace code for exact numbers

I found the code below, it works but its not looking for exact numbers. I have a huge excel document with one column labeled CITY, the names of the cities have been coded. I have another excel document that decodes the city to the actual name. (the actual list is much bigger)

example:
Doc 1

CITY
44516
44
6

Doc 2

CITY CODE
Seattle 44
Boise 44516
Salt Lake 6


The problem with the code is that its not looking for exact numbers. So anytime it sees a 6 it enters Salt Lake.

The code is...

Please Login or Register  to view this content.