Sub 手动换行()
Dim i, j As Integer
For i = 1 To ActiveSheet.UsedRange.Rows.Count
For j = 1 To ActiveSheet.UsedRange.Rows.Count
a = Cells(i, j).Value
Cells(i, j).Value = Chr(10) & a & Chr(10)
Next
Next
End Sub
For i = 1 To ActiveSheet.UsedRange.Rows.Count
For j = 1 To ActiveSheet.UsedRange.Columns.Count
a = Cells(i, j).Value
Cells(i, j).Value = Chr(10) & a & Chr(10)
Next
Next