J
Joe D
Currently I have code that looks something like this:
thisCell.Value = thisCell.Value & " " & newCell.Value
Which adds the new value to the old value, separated by a space.
However, I would rather have this line of code insert a line break. In
the formula bar, CHAR(10) works for this, but I tried to just replace
the space(" ") with CHAR(10) and Excel complains about it. What is the
correct way to insert a line break?
Thanks to anyone who responds,
Joe
thisCell.Value = thisCell.Value & " " & newCell.Value
Which adds the new value to the old value, separated by a space.
However, I would rather have this line of code insert a line break. In
the formula bar, CHAR(10) works for this, but I tried to just replace
the space(" ") with CHAR(10) and Excel complains about it. What is the
correct way to insert a line break?
Thanks to anyone who responds,
Joe