From: Jack Sons on
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
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
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
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
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


 |  Next  |  Last
Pages: 1 2
Prev: Excel does not claculate
Next: Custom Data Validation