VBA inserting chr(10) or vbLf

[Jack Sons]

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

 

[Ron Rosenfeld]

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

 

[BSc Chem Eng Rick]

Use the "replace" function

 

[Jack Sons]

Thanks Rick,

I'm afraid your suggestion will not work because it is unknown what
character we have on position 15. We know only its position.

Jack.

 

[Jack Sons]

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

Jack.

 

[Ron Rosenfeld]

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

Jack.

Glad to help.
--ron