Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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


.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a zero Janice Excel Discussion (Misc queries) 5 August 15th 08 01:31 PM
inserting zero dfg Excel Worksheet Functions 1 May 22nd 06 12:28 PM
Inserting row umba-sr Excel Discussion (Misc queries) 3 April 13th 06 03:56 PM
Inserting a row Tom Excel Worksheet Functions 8 January 31st 06 01:28 AM
Inserting zero ananga Excel Discussion (Misc queries) 2 July 1st 05 05:41 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"