How can you append data to an Excel cell on a new line (i.e. similar to hitting Alt+ENTER)? Topic is solved

[audante]

I'm trying to add new text strings in a cell that already contains some text. Is there a way to append the new text or concatenate the new and existing texts but with a New Line between them? What I have so far is below.

Code: Select all

AddComment(XL,LineNumber,Comment) {

;Get current text in cell
CurrentText := XL.ActiveSheet.Range("W" LineNumber).Value

;Add new full comment
XL.ActiveSheet.Range("W" LineNumber).Value := CurrentText "Need someway to add new line (Alt+ENTER) here" Comment

}

[boiler]

Just use `n for a new line:

Code: Select all

XL.ActiveSheet.Range("W" LineNumber).Value := CurrentText "`n" Comment

[audante]

That worked perfectly. Thank you so much!