On 21/01/2012 10:26 PM, jeffrey wrote:
I'm looking for an alternative to newLine. Currently my code is
written as:
mySheet.getRange("F5").getValue() + newLine +
mySheet.getRange("F6").getValue() + newLine + etc...

Instead of newLine, I just want a line break. newLine is equivalent
to<p in HTML, but I am looking for something like<br. How can I
do that?

Jeffrey

Hi Jeff

try

mySheet.getRange("F5").getValue() & Chr(10) & _
"" & Chr(10) & _
mySheet.getRange("F6").getValue() & Chr(10) & _
etc..

HTH
Mick