Is it possible to get the status of "array of rows" or "punctuation marks of each line (vbCrLf?)" ? The row in the "Rattetext = True" cell, which has a long string and automatic brake in "lines."
Yes, it is possible to consider partial resolution for manual line breaks. is. The code will be as follows (for Activecell ):
sub solution () Dim myArray myArray = Split (ActiveCell, Chr (10)) Return to range cell Activecell ActiveCell.Offset (1, 0). UBound (myArray) + 1, 1) = Application.Transpose (myArray) End Sub The first and the following are presented on the picture below:
Additional suggestions: Instead of Chr (10) You can try using Chr (13) to use if you do not get expected results (other possible dialeters: vbCrLf And vbCr ).
No comments:
Post a Comment