是的,有其它方法也可以的,只要简洁方便
追答右键当前工作表标签---查看代码--把下列代码复制进去即可!
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 1 And Target.Row = 57 And Target = 1 Then
Range("b:b").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End If
End Sub
我用的07,点右键,没有当前工作表标签呢?
追答sheet1 sheet2 这个是当前工作表标签,对着这个标签(表名)点右键!
追问还有就是如果要在其它格用这个命令,要在你上面的代码里面怎么改?麻烦给说说,再加几十分哈~~
追答Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$A$57" And Target = 1 Then
Range("b:b").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
ElseIf Target.Address = "$A$57" And Target 1 Then
Cells.Select
Selection.EntireRow.Hidden = False
Range("a57").Select
End If
End Sub
"$A$57"修改这个就可以了!
不行呀大哥,,假如我要在U19打“1“,来判断V列没有内容的隐藏,要怎么改呢?
你按上面的复制,然后改一下,我就知道其它的怎么改了
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$U$19" And Target = 1 Then
Range("V:V").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
ElseIf Target.Address = "$U$19" And Target 1 Then
Cells.Select
Selection.EntireRow.Hidden = False
Range("U19").Select
End If
End Sub
怎么操作呢