if i use a vbcrlf in a macro a character appears in my excel file.
How can i set two strings in one cell under each other without having the vbcrlf char?
Code:Cells(i, 4).Value = Cells(i, 4).Value & vbcrlf & Cells(i, 5).Value & " u."
Printable View
if i use a vbcrlf in a macro a character appears in my excel file.
How can i set two strings in one cell under each other without having the vbcrlf char?
Code:Cells(i, 4).Value = Cells(i, 4).Value & vbcrlf & Cells(i, 5).Value & " u."
oops, already found it myself
does the trick...Code:vblf