I'm trying to run the same marco on multiple tabs by clicking on 1 button. Is it possible? thanks
Here's the code:
Sub HideRows()
Rows("17:548").EntireRow.Hidden = False
Dim cell As Range
For Each cell In Range("b17:b548")
If Not IsEmpty(cell) Then
If cell.Value = 0 Then
cell.EntireRow.Hidden = True
End If
End If
Next
End Sub
Here's the code:
Sub HideRows()
Rows("17:548").EntireRow.Hidden = False
Dim cell As Range
For Each cell In Range("b17:b548")
If Not IsEmpty(cell) Then
If cell.Value = 0 Then
cell.EntireRow.Hidden = True
End If
End If
Next
End Sub