#1
|
|||
|
|||
vba coding for CrLf in text
Hi All,
How can i code for the addition of an Alt-Enter in the middle of text? I have a table with header rows, some have 2 words in them, after doing an Alt-Enter to put the second word below the first and then centering the text in the field my VBA code no longer sees the field Sheets("Docket").Range("V" & OFF_SET) = Intersect(ActiveCell.EntireRow, tblColumns("Serial Number").Range) I know it's something like "Serial" & VbCrLf & "Number"but can't figure it out. Any help would be appriciated regards Trevor |
#2
|
|||
|
|||
The following works here :
Code:
Option Explicit Sub InsertLineFeed() Range("A1").Value = "Serial" & vbCrLf & "Number" End Sub |
#3
|
|||
|
|||
Thanks for that. new it was an easy one just forgot the syntax for it.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help on separate a single text cell into multi cells by coding | Yasso | Excel Programming | 1 | 12-01-2015 05:45 PM |
VBA coding for multiple drop-down lists to populate a text box for each list | yeatropulo | Word VBA | 14 | 11-11-2015 01:08 PM |
What kind of coding? | ep2002 | Excel | 3 | 07-22-2014 07:52 AM |
text becomes pages of these *** and then coding | EkkoJohnny | Word | 1 | 11-22-2013 12:37 AM |
Converting data-table into coding text | niuri_cigarete | Excel | 2 | 12-10-2011 02:57 AM |