如果你的数据够规范的化,使用下面的代码就可以Sub ch()Dim sr = 2Do While Range("f" & r)""
s = Split(Range("f" & r).Value, Chr(10))
cc = UBound(s)
If cc > 0 Then
Range("a" & r + 1 & ":f" & r + cc).EntireRow.Insert
Range("a" & r & ":l" & r).Copy Range("a" & r + 1 & ":L" & r + cc)
End If
For i = r T