If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VBA inserting chr(10) or vbLf
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 |
#2
|
|||
|
|||
VBA inserting chr(10) or vbLf
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
VBA inserting chr(10) or vbLf
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. "BSc Chem Eng Rick" schreef in bericht ... 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 . |
#5
|
|||
|
|||
VBA inserting chr(10) or vbLf
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 |
#6
|
|||
|
|||
VBA inserting chr(10) or vbLf
On Mon, 10 May 2010 13:49:53 +0200, "Jack Sons" wrote:
Thanks Ron. It's a certaincy that Len(myCell) 15. Jack. Glad to help. --ron |
Thread Tools | |
Display Modes | |
|
|