View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe D[_4_] Joe D[_4_] is offline
external usenet poster
 
Posts: 9
Default Simple Question (insert new line)

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