Error in selecting the range of columns in the same row

Question

Its showing error in selecting a range of columns in the same row. Please let me know what I'm doing wrong here. Part of my code looks like below

    If .Cells(i, "C") = "Major Bridge" Or .Cells(i, "C") = "Minor Bridge" Then
    ****Range("G"&i-1:"L"&i-1).Select****
     Selection.ClearContents

Answer 1

Range("G" & i-1 & ":L" & i-1).ClearContents

or

Range("G" & i-1, "L" & i-1).ClearContents

You might benefit from reading How to avoid using Select in Excel VBA.