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;
For Each cell In Worksheets("Change Master Task List").Range("M:M")
I'm trying to reference (row, 8) of that whole worksheet, cells(row,8) wouldn't reference outside of the ("M:M") Range correct?
c = Worksheets("Timeline").Range("B82:BI762")
For i = 1 To Worksheets("Timeline").Range("B82:BI762").Rows.Count
For j = 1 To Worksheets("Timeline").Range("B82:BI762").Columns.Count
If IsEmpty(c(i, j)) Then
Else
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
End If
Next j
Next i
Bookmarks