kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,934
- Office Version
- 365
- 2010
Before I pull all of my hair out, why is this a type mismatch?
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.
Code:
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.