| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New line vs line break
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
New line vs line break
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
New line vs line break
After serious thinking 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 vbNewline is a combination of 'carriage return' + 'line feed' (vbCr+vbLf), and is equivalent to vbCrLf. So the vbLf is what you want. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| line break does not appear in CSV | Excel Discussion (Misc queries) | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| Line Break | Excel Discussion (Misc queries) | |||
| Macro problem on, Yellowed line - previous line or next line. | Excel Programming | |||
Linear Mode
