Inserting chr(10) from script

[Gav]

I am writing an OLE link from SAP to generate an Excel document and have
come accross a bit of a hurdle. After populating a cell with text I need to
insert carriage returns at specific points.

eg. I insert "This is my test text." into a cell. Then I want to insert
carriage returns after "is" and "test".

I've tried to record macros of me selecting after a character and pressing
alt-enter but in the macro shows the following "This is"& chr(10) &"my
test"& chr(10) &"text."

Is there an insert command I can use to insert a single character?

thanks

Gav

 

[JW]

Try:
"This is" & vbLf & "my test" & vbLf & "text."

 

[Gav]

I am writing an OLE link from SAP to generate an Excel document and have
come accross a bit of a hurdle. After populating a cell with text I need to
insert carriage returns at specific points.

eg. I insert "This is my test text." into a cell. Then I want to insert
carriage returns after "is" and "test".

I've tried to record macros of me selecting after a character and pressing
alt-enter but in the macro shows the following "This is"& chr(10) &"my
test"& chr(10) &"text."

Is there an insert command I can use to insert a single character?

thanks

Gav

I thought that would happen. Half an hour getting knowhere then as soon as I
post I find the answer. )

ActiveCell.Characters(6, 0).Insert (Chr(10))