如果各行内容不相同则
Sub yc2()
For I = 2 To Range("A65536").End(3).Row + 1
If Cells(I, 1) = "" Then GoTo 10
If Cells(I + 1, 1) <> "" And Cells(I - 1, 1) <> "" Then Rows(I).Hidden = True
10 Next
End Sub
第一个问题
Sub yc()
For I = 2 To Range("A65536").End(3).Row
If Cells(I, 1) = Cells(I - 1, 1) And Cells(I, 1) = Cells(I + 1, 1) Then Rows(I).Hidden = True
Next
End Sub
如果各行内容不相同则
Sub yc2()
For I = 2 To Range("A65536").End(3).Row + 1
If Cells(I, 1) = "" Then GoTo 10
If Cells(I + 1, 1) <> "" And Cells(I - 1, 1) <> "" Then Rows(I).Hidden = True
10 Next
End Sub