The macro Charles provided runs fine for me.
The macro will be hiding the row prior to the mismatch.

Try changing the code line of cell.EntireRow.Hidden = True
to cell.Select
and run the macro.

This time when you get the mismatch error I'd suspect whatever is in the next cell to be selected to be causing the problem. Have a look and see what's there.