if you want to use a line break, you have to use "& CHR(10) &",which looks like:Range("c1") = Range("a1") & Chr(10) & Range("b1")