excel - how to get the row width of a wraptext cell in vba -

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 ).