Macro not returning any results

Hi all,

Is there any type of a reason why something won't appear in a cell if the macro is correct? I run the macro and 2 of the cells don't have the info. I KNOW it's fine. I've even recorded the macro a few extra times.

I'm going NUTS here. I already made sure there is no formatting in the cell as well. Pasting the code won't help since I know there isn't anything in the code preventing it from appearing. Any ideas why this may be happening? It's happening in the same 2 columns on the same sheet ALL of the time. I can't figure out why. HELP!