PDA

Click to See Complete Forum and Search --> : vbcrlf char appears when i use it in a macro


schuurke28
Dec 15th, 2004, 07:32 AM
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?


Cells(i, 4).Value = Cells(i, 4).Value & vbcrlf & Cells(i, 5).Value & " u."

schuurke28
Dec 15th, 2004, 07:36 AM
oops, already found it myself
vblf does the trick...