If Statement Issue

I'm getting a Run-time error '1004': Application-defined or object-defined error. Occuring on the bolded line below.
That line is simply trying to check .Range(Row, 8) against "y". The Row variable is retaining the correct correct value so I'm confident that the issue isn't with that. I think I am referencing the worksheet incorrectly?.... Thanks in advance for any help or suggestions.

Originally CStr() was not included, however I am getting the same error before and after the change.

Please Login or Register  to view this content.

TMS ~ What is your advice? c(i, j) is working and is a defined range.

Kaper ~ As you see in the code below, cells(row, 8) would be out of range of the defined range for the For loop;

Please Login or Register  to view this content.

I'm trying to reference (row, 8) of that whole worksheet, cells(row,8) wouldn't reference outside of the ("M:M") Range correct?

Please Login or Register  to view this content.

Cells(row, 8) works I believe... A little confused as to why it does