I have seen several pieces of code like below on how to do this but none fits exactly what I want to do.
What I want to achieve is when I change Cell G4 it will then hide any rows where Column B has a 1 in it between rows 16 and 76.
Sub Test_Hide_Ones()
Application.ScreenUpdating = False
Dim i...