I am trying to set excel to include carriage returns in a cell. The cell contents are intended to be copied for use outside
I have noticed that every time I copy the cell in concern, I get a quotation marks surrounding the text
when I paste it in any text editors like notepad.
Is there a way I could get rid of this annoying addition, the
I am using the following vba to enforce a carriage return in a cell:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheet1.Range("A1") = "First Line" _
& vbCrLf & "second Line"
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I did intially try to use char(10) in the formula in conjunction "wrap text" formatting but this was completely ignored
when copied and pasted in notepad. I believe it is only a visual thing in excel.