Sub 自动设置行高()
Dim X%, RowHeight, Rs%
X = ActiveSheet.Cells(1, 1).CurrentRegion.Rows.count
Cells.EntireRow.AutoFit '自动行高,列也可以用
For Rs = 1 To X
RowHeight = Rows(Rs).RowHeight
Rows(Rs).RowHeight = Round(RowHeight * 1.2, 0)
Next Rs
End Sub
Sub 自动设置行高()
Dim X%, RowHeight, Rs%
X = ActiveSheet.Cells(1, 1).CurrentRegion.Rows.count
Cells.EntireRow.AutoFit '自动行高,列也可以用
For Rs = 1 To X
RowHeight = Rows(Rs).RowHeight
Rows(Rs).RowHeight = Round(RowHeight * 1.2, 0)
Next Rs
End Sub