Thanks Ron. It's a certaincy that Len(myCell) 15.

Jack.

"Ron Rosenfeld" schreef in bericht
...
On Mon, 10 May 2010 12:03:40 +0200, "Jack Sons" wrote:

Hi all,

In a for next loop I want to insert at a certain position (below it is
position 15) in a cell chr(10) (is that called a line feed?) to put the
rest
of the content on a new line in the cell.
I tried

myCell.Characters(15) = vbLf

but that will not work.

What should the code be?

Thanks in advance for your advice.

Jack Sons
The Netherlands



Left(myCell.Value, 15) & vbLf & Mid(myCell.Value, 15 + 1)

You may or may not want to test to see if Len(myCell) 15

--ron