How do I get this to look at the RC[4] and not insert the Hyperlink if there is nothing there?
Code:
        For i = 6 To 82
        
        With Cells(i, 1)
        .FormulaR1C1 = "=HYPERLINK(""http://eic.mycom.com/eic_drw/qr/"" &RC[4],RC[4])"
        With .Font
        .Bold = True
        .Name = "Arial"
        .Size = 12
        .Underline = xlUnderlineStyleSingle
        .ColorIndex = 5
       
        End With
        End With
        Next