Hi,
I'm comparing the string values in a column of Dealer Names to those stored
in an Array of Dealer Names.
My code isn't finding any matches (although there are plenty) & I think it
is something to do with this;

When debug it & step through, I notice that the value of the string in my
array looks something like this;

"Joe Bloggs & Sons Ltd"

but the variable is returning Dealer names from the column that look
something like this;

"Joe Bloggs & Sons Ltd "

I'm guessing the amount spaces between the last letter of the string & the
quotation mark is why no matches
are being found. How can I solve this please,

"MERRY
XMAS EVERYONE ! " :-)