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.
For Each cell In Worksheets("Change Master Task List").Range("M:M")
If CInt(c(i, j)) = cell.Value Then
Row = cell.Row
If CStr(Worksheets("Change Master Task List").Range(Row, 8)) = "y" Then
c(i, j).Interior.ColorIndex = 23
End If
End If
Next cell
Bookmarks