VBA inserting chr(10) or vbLf
in [General]
|
Prev: Excel does not claculate
Next: Custom Data Validation
From: Jack Sons on 10 May 2010 06:03 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
From: Ron Rosenfeld on 10 May 2010 07:17 On Mon, 10 May 2010 12:03:40 +0200, "Jack Sons" <j.sons(a)planet.nl> 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
From: BSc Chem Eng Rick on 10 May 2010 07:26 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 > > > . >
From: Jack Sons on 10 May 2010 07:47 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" <BScChemEngRick(a)discussions.microsoft.com> schreef in bericht news:6CA3BA5C-FC85-46D5-A1EA-D278AC976DBB(a)microsoft.com... > 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 >> >> >> . >>
From: Jack Sons on 10 May 2010 07:49
Thanks Ron. It's a certaincy that Len(myCell) > 15. Jack. "Ron Rosenfeld" <ronrosenfeld(a)nospam.org> schreef in bericht news:0nqfu5pae86lrohdbn4sdvngvnllf2o66r(a)4ax.com... > On Mon, 10 May 2010 12:03:40 +0200, "Jack Sons" <j.sons(a)planet.nl> 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 |