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
|