Type Mismatch

[kweaver]

Before I pull all of my hair out, why is this a type mismatch?

Worksheets("Reformatted").Range("C1:C" & lastrow) = Worksheets("TextFile").Range("I1:I" & lastrow) & ":" & Worksheets("TextFile").Range("J1:J" & lastrow)

The cells in the TextFile are all text. Some cells in columns I and J in TextFile are blank.
I'm trying to concat the two columns with a color between the text.

 

[DanteAmor]

Maybe

  With Worksheets("Reformatted").Range("C1:C" & lastrow)
    .Formula = "=TextFile!I1&"":""&TextFile!J1"
    .Value = .Value
  End With

 

[JJKinVA]

Or slightly tweaked :
With Worksheets("Reformatted").Range("C1:C" & lastrow)
.FormulaR1C1 = "=TextFile!RC9 & "":"" & TextFile!RC10"
.Value = .Value
End With