Run-time 1004 for this With statement

[Noid67]

Not sure why I am getting the Run-time 1004 error message for this With statement:

This line is the culprit:
.Range("M2:M" & .Cells(.Rows.count, "L").End(xlUp).Row).FormulaR1C1 = _
"=INT(RC[-1]/1440)&"" ""&TEXT(RC[-1]/1440-INT(RC[-1]/1440),""hh:mm:ss)"""

With Sheet8 'Sheet8 = SSP_Core
        .Range("I1").value = "SDT"
        .Range("J1").value = "Trailer ID"
        .Range("K1").value = "Seal"
        .Columns("L:L").Insert shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
        .Range("L1").value = "REMOVE3"
        .Range("M1").value = "Dwell Time"
        .Range("M2:M" & .Cells(.Rows.count, "L").End(xlUp).Row).FormulaR1C1 = _
                       "=INT(RC[-1]/1440)&"" ""&TEXT(RC[-1]/1440-INT(RC[-1]/1440),""hh:mm:ss)"""
    End With

 

[MARK858]

Your quotes are in the wrong place try...

.Range("M2:M" & .Cells(.Rows.Count, "L").End(xlUp).Row).FormulaR1C1 = _
"=INT(RC[-1]/1440)&"" ""&TEXT(RC[-1]/1440-INT(RC[-1]/1440),""hh:mm:ss"")"

 

[Peter_SSs]

Also, do you need to do it in pieces like that? Wouldn't this do the same thing?

.Range("M2:M" & .Cells(.Rows.Count, "L").End(xlUp).Row).FormulaR1C1 = _
               "=TEXT(RC[-1]/1440,""d hh:mm:ss"")"