runtime error 400. do you know how to fix it? would it be possible to send
you my spreadsheet?

e

"merjet" wrote:

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