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 f...