以A1单元格为例:
Sub aa()
I = 1
Set rng = Range("a1")
Dim H1 As Single, H2 As Single
rng.WrapText = False
rng.Rows.AutoFit
H1 = rng.Height
rng.WrapText = True
rng.Rows.AutoFit
H2 = rng.Height
n = H2 \ H1
MsgBox "单元格" & rng.Address & " 有 " & n & " 行!"
Select Case n
Case 1
rng.RowHeight = 20
Case 2
rng.RowHeight = 40
Case 3
rng.RowHeight = 60
Case 4
rng.RowHeight = 80
End Select
End Sub
温馨提示:答案为网友推荐,仅供参考