Results 1 to 2 of 2

Thread: vbcrlf char appears when i use it in a macro

  1. Dec 15th, 2004, 08:32 AM #1
    schuurke28
    schuurke28 is offline

    Thread Starter
    Hyperactive Member schuurke28's Avatar
    Join Date
    Feb 2001
    Posts
    402

    vbcrlf char appears when i use it in a macro

    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."
    Reply With Quote Reply With Quote
  2. Dec 15th, 2004, 08:36 AM #2
    schuurke28
    schuurke28 is offline

    Thread Starter
    Hyperactive Member schuurke28's Avatar
    Join Date
    Feb 2001
    Posts
    402

    Re: vbcrlf char appears when i use it in a macro

    oops, already found it myself
    Code:
    vblf
    does the trick...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width