>>>how to make a linefeed without creating a new paragraph
>>>

>>>oRange.InsertAfter(Customer_ID + ": " + Company_Name + ?????) &&& make new line without ending the paragrap
>>>

>>
>>Try CHR(11).
>>
>>Tamar
>thanks Tamar, i tried 14,15 ,8,9 bit not 11.

FYI, I figured it out by recording a macro of typing Ctrl+Enter, which is what I figured you wanted.

Tamar