View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
TheVisionThing TheVisionThing is offline
external usenet poster
 
Posts: 22
Default Programming Line Breaks into Cells

Didn't seem to work.

If I use 'ConvertTextAreaExcel = Replace(strText, chr(13)."#LINE#")', I see
'#LINE#' where the lines should be in the resume in the Excel cell.

But ' ConvertTextAreaExcel = Replace(strText, chr(13),chr(10))' doesn't
introduce line breaks into the cell.

Regards,
Wayne C.