Re: VBA, pulling values together to do a comparison
That suggests it's not finding the value. When it errors, debug and hover over the coloured line and see what the value or 'r' is. I thought you said the tables were identical? If not, perhaps it's not the 4th column.