View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
BSc Chem Eng Rick BSc Chem Eng Rick is offline
external usenet poster
 
Posts: 118
Default VBA inserting chr(10) or vbLf

Use the "replace" function
--
If this helps, please click "Yes"
<<<<<<<<<<<


"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


.