Sub b()
Dim r&
With ActiveSheet
r = .UsedRange.Rows.Count
.Rows("2:" & r).RowHeight = IIf(.Range("a2").Height, 0, 13.5)
.Shapes(1).TextFrame2.TextRange.Characters.Text = IIf(.Range("a2").Height, "收起", "展开")
End With
End Sub 求助2.rar(15.55 KB, 下载次数: 99)
Sub b()
Dim r&
With ActiveSheet
r = .UsedRange.Rows.Count
.Rows("2:" & r).RowHeight = IIf(.Range("a2").Height, 0, 13.5)
.Shapes(1).TextFrame2.TextRange.Characters.Text = IIf(.Range("a2").Height, "收起", "展开")
End With
End Sub 求助2.rar(15.55 KB, 下载次数: 99)