Obvious Cells Not Found

I think this is best explained by the picture attached. In a nutshell, the code below is not finding my cells, thought they're obviously there. I tried replacing ".Value = "Stipend", with "Select" and the code still failed, but I don't understand why. Help would be highly appreciated.

Please Login or Register  to view this content.

To be fair, I'll post the surrounding code in case there's something else that's messing it up.

Please Login or Register  to view this content.

Yep. It's got me stumped. Everything works like a champ until I get to that line.

Sometimes my obtuseness astounds me. I hadn't told it what my new Last Row was. Sorry to waste everybody's time.