View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default Multiple lines in single cell

Range("A1") = "String1" & Chr(10) & "String2"

maybe,

"gti_jobert" wrote
in message ...

Hi all,

Anyone know how to input 2 strings from vba into a single cell, like
the following;

String 1
String 2


Code:
--------------------

Cells(1, 1).Value = "M/C Group By: " & GroupMachine & " " & "Shift Group
By: " & GroupShift

--------------------


The code above puts the strings into the cell without a break.

Any help appreciated!!

Taa laa


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=510524