Thread: [Solved] vba coding for CrLf in text
View Single Post
 
Old 09-26-2021, 02:40 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default 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
Reply With Quote