Need to search cells in a row, find the first cell that contains a string

AB33,
Ran into another snag. Please see the attached file that shows more of my code and what I'm trying to do. Everything seems to run fine, but the cells that are copying based on offsets off of the "CY" cell won't copy down. I put a comment line at the bottom of the code that I'm trying to use so you can see what's not working right. Seems like the offsets aren't working, though they did work (with the .resize) command in the test file that I was working with before. Please take a look and see if you can figure out the problem for me.

Thanks.