What kind of error? If the lines are red in the VBE it's because long
lines can get broken when posted here. The following should be only
two lines in the VBE. (In another sense, it's only one line, given the
line continuation symbol.)


If c1.Offset(0, iCol - 1) 0 Then c2.Offset(0, iCol - 1) _
= c2.Offset(0, iCol - 1) & c1.Offset(0, 1) & ","

Hth,
Merjet