Excel shows value in cell, but VBA finds it empty

I’ve written a macro to compare a list of files and mark duplicates. It fails on the third name in the list, because activecell.value=‘’ (Null) is True, but I can see ‘01 in the cell.

Why does VBA find that the cell is empty?

How can I change the macro to work round this?

Thanks in advance,

Steve