VBA Code - Compare Adjacent Cells In two columns...

[mtt23]

This sounds so simple, but I am struggling to create code to do the following:

On my spreadsheet, using VBA code, I want to compare 2 cells on the same row (adjacent) in the two columns: K and L

If both cells contain the letter "C" I want that row to be hidden, then continue on to compare the next row and complete the same action.

This process needs to start from row 17 until the last row.


Any help would be appreciated...
Thanks in advance!


Just to add; so far I have tried this:

Dim i As Long, n As Long
    n = Application.Max(Range("K65536").End(xlUp).Row, Range("L65536").End(xlUp).Row)

For i = 17 To n
        If Range("K" & i).Value & Range("L" & i).Value = "C" Then
        Cells.Select
        EntireRow.Hidden = True
    End If
    Next i