View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default What are the character codes of a carriage return entered in a comment?

At least on a windows machine, within Excel, I'd say yes.

For Char(13) you would see a square bullet as an unprintable
character, and if you don't have cell wrap on in a cell your
would also see it for Char(10). Alt+Enter gets you an automatic
cell wrap without you having to turn it on in cell, format

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"davidm" wrote in message
...

David,

In VBA, I have long fallen into the habit of using the following
interchangeably to move to the next line:

* Chr(10)*
* Chr(13)*
*VbCrLf*
*VbCr*
*VBLf*
*VbNewLine *

Have I taken too much for granted?


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=391164