|
楼主 |
发表于 2019-11-6 16:49
|
显示全部楼层
在网上抄的代码,240行以上可以隐藏,240到301行就不行了,就算把行号改成301也不行,哪位大神可以帮改下代码
附上抄过来的代码
Private Sub CommandButton1_Click()
Dim zmh2 As Integer, rng As Range
zmh2 = Sheet8.Range("A65536").End(xlUp).Row
Application.ScreenUpdating = False
If CommandButton1.Caption = "隐藏本期余额为零的科目" Then
CommandButton1.Caption = "显示本期余额为零的科目"
CommandButton1.Font.Name = "隶书"
CommandButton1.Font.Italic = True
For i = 4 To zmh2
If Sheet8.Cells(i, 6) = 0 Or Sheet8.Cells(i, 6) = "" Then
'Sheet8.Cells(i, 6).EntireRow.Hidden = True
If rng Is Nothing Then
Set rng = Sheet8.Cells(i, 6)
Else
Set rng = Union(rng, Sheet8.Cells(i, 6))
End If
'Rows(i).Hidden
End If
Next i
rng.EntireRow.Hidden = True
Else
CommandButton1.Caption = "隐藏本期余额为零的科目"
CommandButton1.Font.Name = "宋体"
CommandButton1.Font.Italic = False
Sheet8.Rows("4:240").Hidden = False
' For i = 8 To zmh2
' If Sheet8.Cells(i, 6)Is Nothing Then
' Sheet8.Cells(i, 6).EntireRow.Hidden = False
' 'Rows(i).Hidden
' End If
' Next i
End If
Cells(6, 2).Select
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton2_Click()
End Sub
Private Sub ToggleButton1_Click()
End Sub
|
|