I have attempted to write code to hide rows on a Pivot table where Col E has zero values from row 4 onwards
Code
Sub Hide_Zeroes()
Dim LR As Long
LR = Cells(Rows.Count, "A").End(xlUp).Row
For I = LR To 4 Step -1
If Cells(I, 5 & LR).Value = 0 Then Cells(I, 5).EntireRow.Hidden = True
Next
End Sub
I need someone to kindly assist me